Hello Everyone.

I'm working on a simple project where I menage warehouse orders.
I have 2 tables: orders and products with a table in the middle (ordersProducts) to handle a many to many relationship.
When I create a new record in products (or update an existing one) I need to select an order and this works fine using a drop-down list with a value list populated with the order numbers.


Now when I add an order number to an existing product I'd like to display in the drop-down list only the orders not yet associated to the product. I sent a couple of hours trying to figure out how to achieve so but no ideas so far.

Is it possible to achieve what I'd to do? If so, can anyone point me in the right direction?

Thanks for any help and have a nice day.


Sig


Sent with Sparrow (http://www.sparrowmailapp.com/?sig)

#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>