Form entry to create join between two tables

towners

Board Regular
Joined
Mar 12, 2009
Messages
225
Office Version
  1. 365
Platform
  1. Windows
Hi, I'm relatively new to Access.

I have two main tables, essentially these are item masters with unique records: "SupplierParts" & "MyParts"

Many supplier parts can relate to one MyPart i.e.:

MyPartSupplierPart
Part1Part1
Part1Part2
Part1Part3

Etc...

I have created a third table ("ItemLinks") to link the two and this has fields: "MyPartNum" & "SupplierPartNum".

I want to use a form to append records to the "ItemLinks" table, creating a new record for each MyPart and SupplierPart combination. The form needs to validate (i'm thnking drop down lists) both MyPart and SupplierPart to ensure they exist and prevent data entry errors.

Can anyone suggest how I might achieve this?

TIA,

Towners
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Combos on the form, each with its rowsource set to the required main table field. Set "Limit to List" to yes to prevent user additions to the list. Admin then has to add new list items. Can use 'cascading' combos to filter subsequent combos based on selection of 'parent' combo.
HTH
 
Upvote 0
Hi, thank you very much.

I have created a form and can select the unique keys from each table.

How do I enter this data into a new record in my "ItemLinks" table?

I really am new to this.

Regards,

Towners
 
Upvote 0
If your form is bound to that table, then simply entering data or making combo selections will create the records automatically. It seems like you need to review some videos or documents about how to do this stuff if you're totally in the dark about it. I think this forum is ok for helping solve issues but it's not really set up for training. A lot of people like Steve Bishop's videos so maybe start there?
 
Upvote 0
Good luck. There are tons of videos made by various 'instructors' if you're not fond of any particular one.
 
Upvote 0

Forum statistics

Threads
1,223,249
Messages
6,171,031
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top