foreign key in a text field

[Jon]

Great program.
Does anyone know a way I can check a text entry on the insert form to make sure it is one of the values of another table. I know I can do it with a select single but my database is too large to scroll through all the options.

Ex.
2 Table (Inventory, Order)

Inventory has Ser_num and Desc.

Order has Ser_num

I want someone to fill out a text field for Ser_num in order but that Ser_num must exist in inventory or I want the insert to fail. Any ideas?
Thanks a lot

 

[Eugenio]

Jon wrote:
>
> Great program.
> Does anyone know a way I can check a text entry on the insert
> form to make sure it is one of the values of another table. I
> know I can do it with a select single but my database is too
> large to scroll through all the options.
>
> Ex.
> 2 Table (Inventory, Order)
>
> Inventory has Ser_num and Desc.
>
> Order has Ser_num
>
> I want someone to fill out a text field for Ser_num in order
> but that Ser_num must exist in inventory or I want the insert
> to fail. Any ideas?

It is not possible at the moment.

(Latest version of DaDaBIK when this message was posted: 2.2.1 beta)