I kindly request for a specialist help, probably a database designer or administrator.
I have been encountering this problem setting a referential integrity for two tables, setting the referential integrity is not the issue but the challenge I am having is that when I am done setting this referral integrity, it doen’t allow null values in the other table which implies that both tables should contain probably the same no. of rows that’ll make it both tables correspond
This is an example of exactly what I want to do:
- I am creating tables, one named “Stock” which is meant for storing goods or accessories that are available in store and another table named “Customer_Details”
- I want to set a field in both field (i. e. a field named “availability”) which will be a Yes/No data type, this field should be present in both field
- Any time a customer is purchasing a particular accessory which is chosen from “Stock” table, it will automagically change the value of the field “availability” in the stock,
All I know and have been trying to do is to set the referential integrity in the relationship window, but unfortunately, this is not working out,
I kindly seek for someone who can put me through on how to go about this as I am new to access 2007.