I have 2 data access pages. The first has a list of buildings, the second a list of staff assigned to buildings.
I use hyperlinks from the first to go to the second and filter based on building. I want to use the second to be able to modify which staff are assigned to the building. This works flawlessly if there is at least one person ALREADY assigned... the the record pops up with record nav buttons to add/delete records.
BUT if no assignment exists, then the page comes up blank!!! I want the second page to pop up with a new record for a staff assignment if there is not one already.
Please HELP!
I use hyperlinks from the first to go to the second and filter based on building. I want to use the second to be able to modify which staff are assigned to the building. This works flawlessly if there is at least one person ALREADY assigned... the the record pops up with record nav buttons to add/delete records.
BUT if no assignment exists, then the page comes up blank!!! I want the second page to pop up with a new record for a staff assignment if there is not one already.Please HELP!
