Help with relating fixed data to other fixed data?
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.