yes it is possible.
In item table make a field (say A)
that field is a dropdown list having value list from supplier name from supplier table.
Then for each entry item you can choose supplier name from the dropdownlist.
Thank you for the reply.
When I make a drop-down list based on Supplier::Name it won't let me change the value. This is because the name of the supplier isn't the foreign key, SupplierID is.
I want a drop-down list that, when choosing a supplier name, will update SupplierID for me automatically.
Means when yiu change the supplier name from the dropdown list then the supplier_Id changes auto matically.
so you write a script and attached by triiger(on object exit)
Take the supplier name by variable go to supplier layout copy the id ,return back to item layout and set that id.
then see .........
I would suggest you make a Value List using the option "Show values from a field...", and choose the Supplier ID. Then use the right side of that set-up dialogue to 'Also show values from a second field' and choose the Supplier Name. Then select to 'Only show values from the second field.' Attach the value list to the Supplier ID field in the Items table.
This will make the pop-up display the list of Suppliers' names, but when you select one it will correctly insert the corresponding Supplier ID.