TRYING TO LINK ALL FORMS TO ONE TABLE

[prodcontrol]

I am not to sure of how it works, I just know what I need to do. I need to link all form to one table with 3 primary keys that allow dups.

any suggestions?



prodcontrol.

 

[Blorf]

I think we need more information. You want to link all forms to one table? Explain.

ChaZ

Ascii dumb question, get a dumb Ansi

 

[prodcontrol]

OKAY!

I have a total of four forms that I want to link to one table. I want to make it so that after setting my three primary keys the forms (when data entered in) will automatically que the correct record on the table and fill in the missing data with the information that was entered on the form.

Is this possible and how?

Im an Access amiture....



prodcontrol.

 

[BNPMike]

prodcontrol
Keys don't allow duplicates. Indexes might but a key is something that identifies one single record. Maybe you mean each of the 3 fields individually might have duplicates but together they don't.

A table (or query) can be connected to any number of forms. If you make an insertion or update on one form and then move to the next, the update from the first form will automatically be made to the underlying table(s)as you leave it.