Hello,
I have multiple columns that look up values from othe tables, but I need them to be dependent, as:
I have these tables:
corporate
division
location
Individual_Customer
After a corporate parent is selected in that column, only a handful of divisions should be available. Then after division is selected, only locations in that division would be available. After picking a location, only customers tied to that location would be choices.
It is also possible that not every customer/location will have a division or a coporate parent. A customer may also have a corporate parent but the parent is small enough that there are no divisions. Or they may have just have a location but no corporate parent.
We are OK with entering a new division before entering the customer in that division. Same with entering a new corporate parent in a form first.
But how can I make these columns dependent and must be filled in the specific order to make it work? Later, when a customer or sale is selected, I need the report to show the Location, Division (if applicable), Corporate (if applicable). Also need to be able to sort by these criteria.
I should add that I am working in a web database so most of the table functionality is still there, but there may be slight differences.
Thank you!
I have multiple columns that look up values from othe tables, but I need them to be dependent, as:
I have these tables:
corporate
division
location
Individual_Customer
After a corporate parent is selected in that column, only a handful of divisions should be available. Then after division is selected, only locations in that division would be available. After picking a location, only customers tied to that location would be choices.
It is also possible that not every customer/location will have a division or a coporate parent. A customer may also have a corporate parent but the parent is small enough that there are no divisions. Or they may have just have a location but no corporate parent.
We are OK with entering a new division before entering the customer in that division. Same with entering a new corporate parent in a form first.
But how can I make these columns dependent and must be filled in the specific order to make it work? Later, when a customer or sale is selected, I need the report to show the Location, Division (if applicable), Corporate (if applicable). Also need to be able to sort by these criteria.
I should add that I am working in a web database so most of the table functionality is still there, but there may be slight differences.
Thank you!
Last edited:
