I am trying to create a database that links up a Firm Name, a Firm Office, and Firm Address. When the user chooses a Firm Name (let's say "Law Firm", the table then formats the next field to the different offices the firm has (let's say "Chicago," "New York," and "Los Angeles". The next field then lists the address of the office that the user chose. Let me map it out for clarity.
Law Firm
--------> Chicago
New York
Los Angeles
(user chooses New York)
------------> 1234 Broadway, New York, NY
This is trying to be a predictive table depending on what the user chooses. I am unsure, however, how to set this up entirely. Please swiftly help me out as a Christmas gift. Thank you in advance.
jgi.
Law Firm
--------> Chicago
New York
Los Angeles
(user chooses New York)
------------> 1234 Broadway, New York, NY
This is trying to be a predictive table depending on what the user chooses. I am unsure, however, how to set this up entirely. Please swiftly help me out as a Christmas gift. Thank you in advance.
jgi.