Hey all,

I have a contacts table with all names and addresses. I have a second table with location specific information. Every location has a contact from the contacts database so I have placed fields accordingly from the contacts table onto the locations layout. The full name (calculation) field from the contacts database = on-site contact in the locations database.

What I'd like to achieve is that when somebody enters an on-site contact it auto-fills the rest of the info (address, phone numbers) automatically based on the info in the contacts database.

I think I have all my relationships right but I still can't get it to work and haven't had much luck with look-ups either.

All help would be highly appreciated.

Best,

R.

Hmmm...well I wanted to create a simple way of linking a contact to a location. I understand that using a name as a relation would undermine my efforts.

Basically I want to avoid duplicating information in the tables (address info) but have a very simple way of linking them. Contacts are in one table and because of the amount of detail required to describe a location we have location specific fields in another table (it would just become to overwhelming).

I'm working based on recommendations by other developers but there could be a smarter way of doing this...?

Thanks for your help.

R.

Contacts database contains contact info. Locations database contains locations specs. Not all contacts are locations but all locations have contact info. I have the contact info before I have specs and there's not much I can do with specs if I don't know how to contact the location (or where it is).

So I have a contact, I want to be able to create a location specsheet in the locations database, enter in a contact name (or ID#) and have all other contact info fill in automatically. So then I just click on the button that switches me between the contacts database entry and the locations entry. But which ever I'm looking at, location or contact layout, I always see the basic contact info.

Does that clear it up? If you send me an email address I can send you the file as well.

Thanks again.

R.

Thanks so much, I seem to be getting there. It works fine now that I've linked the ID's. The way it works now is if I manually type the corresponding contact ID into the location ID field it fills in information for contact fields I've placed on the locations layout. And i think that's PERFECT

I thought it would be a problem to have the ID numbers identical like that, but I just realized that all I need to is call it a "reference" field or something and that way it will still have a unique serial number.

So now I just have to figure out how to connect several locations to one contact...

Thanks so much. I think this will work out fine. The problem must have been that names weren't unique enough and would pull information if there was duplicate or conflicting information.

Yeap, thanks so much. It's working fine although I was using a copy+paste method instead of a drop down list.

Since I have been experimenting with linking entries within a table. So far so good. I want to connect companies to employees but keep them in the same table. I'm not sure whether I should create a secondary serial number as a company ID or always use the primary serial number when creating these relations.

Thanks for all your help. It really did make a difference.