In access 2007 how can I go about it if I want to (for example create two tables “stock” and “customer) and I want to create a particular field that'll be present in both fields (i.e a field like “availability” which will probably be a yes/no data type)
I want this field to be present in both tables, now, if I have a good that is stored in the “stock” table and the customer wants to purchase, I already have a lookup field that will help me access those goods alongside with the properties all from the “stock” table,
But the challenge now is, how do I go about it if I want the availability of a good which I already selected from “stock” table to automatically change the value of the availability to a “NO” value
The previous paragraph talks about the challenge am encountering, though I already successfully done everything but I have to go back to stock and update manually (i.e set the value of a particular goods to “NO”) which is exactly what I don't want, I want to do something better, i.e make it automatically update in the “stock” table
Is there something I am missing, or is there a code that ll be responsible for that?