I would like to know if there is a way to link orphan records back to their primary table. Cascading tables owners table one to many to wells table some 500 wells have no owner and i need to link them back to an owner in the owners table all 500 have same owner please advise!
OK you guys and gals are great but here is another one what is the easiest way to query from one date to another. Like from 09/01/2003 through 09/30/2003. Or is there an easy way to set it up where you can prompt to enter the dates to query?
Thanks
David
Please advise best way to build and relate table
Owners table to wells table to inspections table fine then i want to go to 6 different kinds of inspections with only one it relates great where i can cascade delete when i add second table for second type of test it messes up please advise.
Thanks
Have created a query then form from the query involves 4 tables. form shows in design view but when i switch to form view nada. Nothing shows up
please help.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.