ms access - Form - Create new record in *different* table based on current form data -

-

i'm building risk , issues tracker , have become stuck after initial progress. i'll explain setup now.

tables

  • a table containing open projects
  • a table containing open risks , issues

relationships

  • a one-to-many relationship between project id (primary key in project table) risks , issues table

queries

  • a query filter results projects table have been selected in combo box

forms

  • one form containing combobox allows user select project. there text box, populated based on selected project. text box populated using dlookup on above query, , have chosen field populated that. works fine.

i able select project , see little information using above set up. next step me able add risk or issue.

what happen have create risk / issue button, pull across project id (primary key) selected project, , add new record in **risks , issues* table. need add in additional information risk, dates, owner etc.

also, having project primary key tied each risk, should able pull in additional info project require.

i can write more if required - i'm not sure information needed. also, form 'sits on' projects table have been wrong way of doing things, still don't know how bring in data 2 different tables.

i appreciate effort , patience put towards this.

from understanding of question sounds trying update risks , issues table single form bound projects table. if you're adding record risk issue table bound form needs bound table. best answer start fresh new form created wizard.

  1. make sure have fields want in form in risks , issues table.
  2. create form based on table using wizard.
  3. change project id control combobox right clicking , selecting change to, combobox.
  4. set row source take project id , project project table , make sure project id bound field , project displayed field(by adjusting column widths , bound column properties).

after doing should have form updates risk , issues table while selecting project project table. if not asking or wanted different way let me know i'll see if can help.


Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more