2 fields from 1 value list or links

[lynxbci]

Hi,

I am reasonably new to Filemaker but have extensive Access knowledge, so not a complete beginner.

The Goal: 2 populate 2 fields from a value list

The Source: A Supplier table with 2 fields i am interested in SUPPLIER and ADDRESS

The Destination: A form with 2 fields SUPPLIER and ADDRESS

I have a value list created from the supplier table with just SUPPLIER and this populates the SUPPLIER field on the form OK.

Then i would like the ADDRESS field on the form to be completed using the appropriate address for the SUPPLIER already chosen.

The Question: Can this be done?

Thanks

[bcooney]

Once you have your supplier foreign key populated in your second table (PO, perhaps?), then set PO_Address to a lookup field, using a relationship from PO to Supplier by SupplierID.

Here's a demo. I'd probably break the Address into separate fields (Addr1, Addr2, C, S, Zip).