Records on Home table accessed by two forms
I have role (cost Management) which is responsible for adding/editing records depending on the category of project. So effectively two external parties are responsible. I have created two forms bu...
Forum Discussion
There are two choices.
you can make two relationships with two fields. Then have a final calculated field for the one that was used and use that to make the real relationship where lookup fields are brought in.
The better alternative though, is to have the user first select the type of project, and then the drop own would only list projects of tht type. That is called a conditional drop down.
you can make two relationships with two fields. Then have a final calculated field for the one that was used and use that to make the real relationship where lookup fields are brought in.
The better alternative though, is to have the user first select the type of project, and then the drop own would only list projects of tht type. That is called a conditional drop down.