Hey pplz,
Got a question regarding reports!!
So I have:
TblSuburb
SuburbName
Postcode
Then I have
Customer
SuburbID
Employer
SuburbID
InsuranceCompany
SuburbID
Now I have a report with:
Customer, Insurance Company and Employer on there all with their addresses and im having issues!
If I add SuburbName to the report how do I know which suburbID it is referring to!?
At the moment I am just adding suburbID of all the above and then using Dlookup on the report but I know this is a bit of a stupid way of doing it!
Ideas/advice most welcome
Gangel