Warehouse DB

[vugar]

Could you please help to this issue.

In attached file I trying to create Warehouse DB.



In Outgoing Query I try to set validation rule that when I can't write Quantity if i this item is not avilable in Incoming.

Could you please help how I can do it.

Because the I can't create relation with Outgoing and Incoming?

Thank you
WDB.zip

[ranman256]

you dont need the relationship. you only need relationships with master/child keys. (like client-invoices)
(where you dont want to orphan the child records.)

can you validate BEFORE the record leaves a form? during user input?
if this is bulk imported data , then you must validate before your outgoing can run and mark/remove bad records.

[June7]

Validation does not take place in query, it is done in form design. As ranman suggests, code in the form or control BeforeUpdate event. Or configure a combobox to list only items that are available.