Very New at this trying to learn I want a table that will auto fill and allow me to add something

[Dualxeon]

Ok I keep getting stuck I am trying to create a simple data base to keep track of some inventory. I created a table1 (Inventory ) with item number, Item Category, and Preferred Vendor. Then table2 (Preferred vendors) then i created a relationship between table1 ID and table2 Preferred vendor seems to work. My problem is if I enter a new name that's not in table2 I get name not in list pick one in list how do i fix it where I can add new at this point. Please keep it simple I am trying to learn. Thanks

[ranman256]

you dont need the relationship. Vendor should be a lookup table for the user to pick from to add to the tInv. record.
This way you can add inventory and pick vendor once vendor is added.

and you can still join the tVendor to tInv in queries.

[Dualxeon]

Thanks that got me moving again little by little

[Dualxeon]

Ok thought I had, it been at it so long today, I think I'm seeing things. I created a table Preferred Vendors then set up look up wizard in my Inventory Table. It will let me enter in things I have already entered in the preferred vendors table but won't allow me to add new one here. I know I had that earlier ??

[ssanfu]

It sounds like you have Look up FIELDS in your tables. This is a bad idea. You should have a combo box on a form and a Vendor table.
In the attached dB is a basic form. I added a few extra fields to the tables. If you want to add more data to the fields for vendor, you would need to have the VBA open a form to add the data.

[Dualxeon]

Okay Thanks that does what I am trying to do. Now I have to try to figure out how you do it. I will try to look at what you sent me to get it going.
Thanks Dualxeon

[Dualxeon]

WOW way over my head thanks I'm still working at it.