How to update a link table on a form, Do I need VBA in the form?

[sesproul]

Hello,

I am a sql Server / Web developer, that is using Access for a project, and here is what I need to accomplish.

I have a table that lists Processes

I have a link table that has a record for Parent / Child relationships

I need to bring up a form that lists the Process, (typical information FORM), then has two list boxes (Or combos) that allow a drop down where you can select the Parent process of this process, and the child process of this process. I'm keeping it simple with allowing single parent and single child processes for this form.

Is there an example of this on this forum that I may emulate?

In the web world, I would populate the two lists with the output of a select statement on the tblPROCESS
(Select PROCID, PROCNAME FROM tblPROC),

then after the submit on the page, perform a Single INSERT statement with the relationship into the tblPROC_PROC Table with the PK's of each Process.


Thanks for any help.


Steve

 

[fibayne]

I use Office 2007 which has on the Database Tools toolbar 'Linked Table Manager' open this and it shows all your linked tables select the one you want and hit update...might be a bit simplistic for what you are looking for though Fi

 

[sesproul]

Thanks - I believe the term Linked Table in Office refers to Linking and connection to a datasource.

I have a tblPROC_PROC table that has three fields, a Primary key for the table, the ParentID pointing back to the Primary key of the tblPROCESS table, and the ChildID field pointing back to the Primary key of the tblPROCESS table.

this is the table that keeps track of the relationships, this is the table I need to update in the form.