I have four tables:

Org for organization records (name, address, etc.)

Client client records (name, specialty, etc.)

Office organization office location records (city, mileage, etc)

Visit Visit to client records (date, client, etc)

On Visit records I would like to select a Client name from a drop down list and then an office city from a drop down table. I’ve been trying to set up value lists do this, but I can’t figure out the relationships.

Visit.zip

Are all of these correct:

• Each visit is to one client only;

• Each client belongs to one organization;

• An organization can have many offices;

• Each visit is to one office only.

yes

How about this way, then?

Visits2.fp7.zip

Automatic message

This topic has been moved from "FileMaker Product Family → FileMaker Pro 11" to "Database Schema & Business Logic → Relationships".

The General topic areas are intended for the discussion of the functions, features and tools that were new with the particular version mentioned.

All how-to question should be posted to a topic area that best matches the sprit of the problem. Many questions can fit into more then one area, but you only need to pick one, and go with it.

If you have any questions about this action, please contact me through a private message.

Lee

The solution looked great at first. However, when I create a new visit record the fkClientID and fkOfficeID fields display "no values defined" instead of a drop down list. Do you have any thoughts on that?

John

The solution looked great at first. However, when I create a new visit record the fkClientID and fkOfficeID fields display "no values defined" instead of a drop down list. Do you have any thoughts on that?

John

you have to either put in values or use the field which value list is referencing in order to populate the Value list.

i have tried and have no issues . Confused! :logik:

The solution looked great at first. However, when I create a new visit record the fkClientID and fkOfficeID fields display "no values defined" instead of a drop down list. Do you have any thoughts on that?

That's not what I see. You need to select the client first. Once you have done that, you will be able to select the office too.

Nope, I still can't select a client name on new visit records. I've made no changes to your file, but I'm attaching it to this posting. It's labeled Visits3 just to avoid confusion. It has two new records with only dates entered. I can't select a client name. Give it a try. If you can, then? ? ?

John

Visits3.zip

Forget my last (sending visits3). I found I inadvertently changed the value list on the file you sent me . It's working fine now.

John