Auto-fill fields based on name

[customfamily]

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.

[customfamily]

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.

[customfamily]

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.

[customfamily]

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.

[customfamily]

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.