Recent content by joiry

Look Ups Hmm.. I don't think I've been successful in communicating my issue. Let me try another way. Attached (I hope these aren't too large), I have some pictures of my forms. Example 1: A picture of my base form and sub form. As you can see, I have a drop down, which references a look...

colors The widgets can come in multiple colors. As little as one and as many as 8. As it is today, I have a continuous subform, so during input I give the base widget information, then in the sub form I select the first color. This creates a second drop down box for the second color and so...

I’m fairly new to Access so I hope I can get the terminology correct. I’ve been working on creating a database which has a one to many relationship. With the help of the people in the table forum, I do have that working correctly, and even have a form and sub form where the data can be...

Table Ok, thanks for all the help, it seems to be working now. I've performed most of the suggestions. I'm far from a DBA, so I'm not educated as to standards for table and key naming conventions but I can see how that will be of value. Especially if someone else looks at this or I come...

One to Many Relationship Ok, with your help and a lot of trial and error I think I might have this setup. As a double check, I created a widget database which has two "one to many" relationships and a quick form for me to input data. It's not pretty but seems to be working. Is this proper setup?

I hope I can form this question so it makes sense. I’ve been trying to figure out a way to do this, if it can be done at all. Ok, imagine I’m making a database of widgets. In this database I’m creating a table of widget name, cost, weight, and color. This part is pretty simple. Now, my...