Thanks for the reply
No im not storing the addresses in multiple places :)Just in the appropriate tables
I have the following tables:
FK Event Type (via a lookup table)
RSVP (lookup- accept or decline)
I have a form "mainform" based on TblEvent and the code is:
SELECT TblEvent.EventID, TblEvent.EventType, TblEvent.ClientID, TblEvent.EventTheme, TblEvent.EventDate, TblEvent.Location, TblEvent.StartTime, TblEvent.Budget, TblEvent.NumberOfPlaces, TblEvent.Notes
On the "mainform" i have a subform "eventattendsubform" which is located on a tabcontrol. This subform is based on TbleEventAttended and the code for that is:
SELECT TblEventAttended.EventAttendedID, TblEventAttended.EventID, TblEventAttended.ContactID, TblEventAttended.RSVP, TblEventAttended.NonAttendance, TblClient.CompanyName
FROM (TblClient INNER JOIN TblClientContact ON TblClient.ClientID = TblClientContact.ClientID) INNER JOIN TblEventAttended ON TblClientContact.ContactID = TblEventAttended.ContactID;
On the second tab i would like the user to be able to enter the costs related to the event. She would be able to select from a drop down box any of the companies that are listed in the TbleServiceCo. When she selects the company, i would like the other controls to be automatically filled in with the address details, (just for the users benefit as it would be easier for them) then she would enter the type of service provided and the costs associated with that service.
Also, if the service company is not listed in the drop down box, she needs to be able to go to the table (via a form which i will create) to enter the necessary data - then to come back to the "mainfrm" where she left off.
Are my tables set up correctly to do this? and if so, how do I do this? or what am I missing here? I don't actually work with SQL, i do it all the old fashioned way but i am learning.
I hope i have explained this correctly, i wish could attach pictures etc, but as i am at work, i don't have access to anywhere online i can store anything.
I would just like to say a BIG
thankyou to you, as you have helped me through this forum, so much over the past years. I have learnt so much and my databases are getting better and better.