Question Relationships and Linked Forms

[mcclunyboy]

Hi,

I thought I knew a little about Access but I think I have lost touch.

I was hoping someone could provide me with examples / tutorials to gain a better understanding of this.

My DB tend to have 1 key table with multiple lookup tables. however I am trying to practive by creating a database which holds application details and contact details for support. 2 key tables are the "tblapplication" and tblcontact - i would like to enter application details with a button to add contact details if we have them.

 

[mcclunyboy]

OMG I got it working by myself...

My first piece of VB code created without looking at anything and it works (3rd time lucky i guess)...

I use this to link the 2 fields :

Dim app As String
    
    app = Me.txtApplication
    DoCmd.OpenForm "frmContacts", acNormal
    Forms!frmContacts.txtApplication = app

it takes the text from the txt field in the 1st form and adds it into the 2nd.

Is this what i should be doing!?