Forms with drop down values from another table?

[Dabrowski]

I'm wondering if it's possible to have:

Customers Table
- Customer ID
- Customer Name

And

Domains Table
- Domain
- Customer ID

Customers->Customer ID is related to Domains->Customer ID (1:n)

Have a form for Domains that has a field for:

Domain: Text input
Customer: Drop down with Customer Name displayed, but it inputs to the Domain table as the Customer ID.

[RPG]

Hello

I think what you want is possible.

For understanding forms see here.

There are more links what can help you.

In your case make the property for the bound field empty when you use a listbox.
The relations are important for the database but are not important how the form is working.


Romke