AnsweredAssumed Answered

Help with relating fixed data to other fixed data?

Question asked by dkirk_vei on Oct 12, 2011
Latest reply on Oct 13, 2011 by philmodjunk

Title

Help with relating fixed data to other fixed data?

Post

This is probably a really simple question, but I'm a new user with little database experience. I work for an oil and gas company and I'm having a few issues with relationship and my records. Here's what I've got so far.

I've got one table set up with the following fields: Property_Name, Property_No, Company, and Field

I'm trying to link the Property_Name with the other 3 fields (Property_No, Company, and Field) since that information never changes. The overall goal would be to do a Drop Down List of the Property_Names, select one and then the rest of the information fields fill in with the Property_No, Company, and Field. 

Any help would be greatly appreciated.

 

Outcomes