Error message in tables!

[sunshine]

I created a small database with three table 'parts' 'jobs' abnd 'suppliers'. I have created forms and queries and am now trying to add some records into my 'parts' table. However every time i try to do so, an error message pops up saying 'you cannot add or change a record because a related record is required in table 'supplier'. What does this mean and how do i fix it??

[Rawb]

What that means is that you have to have a Supplier for your part. Either you're trying to add a part for a supplier that doesn't exist or you're leaving the supplier's field blank when you create the part.

If you create the appropriate supplier first, then you'll be fine.