Thanks so much for replying – I assumed you had given up on me for my cluelessness. *sheepish grin*
I set the tables and relationship up the way you have outlined. Yay!!
The invoice total isn’t a derived field – it’s just the total that I enter from the invoice. I decided it would be better...
I’m not sure what you mean by “normalized”. I’m only trying to join on the productnumber column, which (I thought) should be a 1:m, but it’s coming up as a 1:1.
Description, unitmeasurement, weight, etc. repeat in both tables because I thought I needed to do that in order to add those records...
I’m trying to specify it in the relationship window. I don’t get any error messages, it just automatically is a 1:1, and I don't have the option of changing it. I thought that maybe it was because the data types were different in the five corresponding fields, but they're all the same. Is there...
I am a newbie. I need help very badly.
I have two tables: tblinventory and tblpartslist. I want to create a one-to-many relationship between them, and Access isn't allowing it. I have no idea why. The data types are the same, and there are 5 fields in each table that should correspond to each...
I have two tables - tblinventory and tblpartslist. I would like to create a form from tblinventory, with tblpartslist as a subform, so that I can enter a list of products for each inventory record. I would like to be able to enter a product number into the tblpartslist subform, and have it...
I have two tables - tblinventory and tblpartslist. I would like to create a form from tblinventory, with tblpartslist as a subform, so that I can enter a list of products for each inventory record. I would like to be able to enter a product number into the tblpartslist subform, and have it...
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.