Linking a form to another form

[Waldin]

could i link a current form to another form, these would be to seperate enties but the client may be the same so all documents (forms) from the same client would be linked together and visible.

 

[MStef]

You have got 2 tables, "tblDocument", and "tblClient". Populate RELATIONSHIPS (tblClient : tblDocument, 1: more). Make a Main Form on tblClient, and form on
tblDocument. Thise second form put in Main Form as a SUBFORM. Link them via
LINK CHILD FIELDS, and LINK MASTER FIELDS properties (in Subform). Tray to enter 1 record in Main Form, and for this Client more records in Subform.

 

[Waldin]

thanks Mstef, im busy applying it, it makes sense just by reading it.

 

[Waldin]

Populate RELATIONSHIPS (tblClient : tblDocument, 1: more)

please elaborate on the above Mstef

 

[speakers_86]

What he is trying to tell you is to create relationships. Click on database tools, and then Relationships(if you've got the ribbon). In the show table dialog, you will need to show tblDocument and tblClient. You will then drag the primary key of tblDocument and drop it onto the foreign key in tblClient. Access will draw a line connecting the two. If you double click on that line, Access will give you options. You want to enforce referential entegrity.

I recommend that you research this (and normalization if you don't know what it is). I feel like I cant fully explain relationships here, plus I'm off to work now.

 

[Waldin]

easy peasy.

thanks speakers.

 

[MStef]

Look at "Relationships" (attachment, word).