I'm sure there is a really easy answer to my question.. I don't seem to get it right though...
I have to forms based on to different tables..
This is the most important part of my forms:
Contact: ContactID, LastName, Firstname, CompanyID (lookup to a different table)
Prospect: ContactID (showing LastName, FirstName), CompanyID etc...
1. When I want to create a new Prospect, the user have 2 way to fill in the prospect.
1.1 If the Contact is already in the contactregister, I want to find his name in a combobox, then the company shows up automatic... I know how to create the combobox.
1.2 If the contact is not in the contactregister, I want a button that takes my to the contactfrm.. Then I want a button on the contactfrm, that opens up the prospectfrm and fills in contactname and company automatic. from the contactfrm..
Sorry for my lack of english.. I think!
Vegard
I have to forms based on to different tables..
This is the most important part of my forms:
Contact: ContactID, LastName, Firstname, CompanyID (lookup to a different table)
Prospect: ContactID (showing LastName, FirstName), CompanyID etc...
1. When I want to create a new Prospect, the user have 2 way to fill in the prospect.
1.1 If the Contact is already in the contactregister, I want to find his name in a combobox, then the company shows up automatic... I know how to create the combobox.
1.2 If the contact is not in the contactregister, I want a button that takes my to the contactfrm.. Then I want a button on the contactfrm, that opens up the prospectfrm and fills in contactname and company automatic. from the contactfrm..
Sorry for my lack of english.. I think!
Vegard