Clients 1>m Contracts 1>m link m<1 Scanners 1>m reports
Contracts can be added; modified or deleted; this includes adding and removing scanners.
on removing a scanner from a contract I would (I think) need to delete the associated link from the junction table. However, there are reports for scanners which I must keep.
I've setup a couple of forms to enable me to add contracts and scanners but I do not know how to remove scanners from existing contracts. Can the link be updated (delete and add) to move the scanner to an "obsolete contract" - or is there a better way to handle this removal ?
If I understand you correctly, you have a many-to-many table called links, which has pointers to the Contracts and Scanners tables. Each of the records in this table indicates how any Contract can connect
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
When developing Access applications, often we need to know whether an object exists. This article presents a quick and reliable routine to determine if an object exists without that object being opened.
If you wanted to inspect/ite…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…