Form entry to create join between two tables

towners

Board Regular
Joined
Mar 12, 2009
Messages
222
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 a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
2,449
Office Version
  1. 365
Platform
  1. Windows
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
 

towners

Board Regular
Joined
Mar 12, 2009
Messages
222
Office Version
  1. 365
Platform
  1. Windows
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
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
2,449
Office Version
  1. 365
Platform
  1. Windows
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?
 

towners

Board Regular
Joined
Mar 12, 2009
Messages
222
Office Version
  1. 365
Platform
  1. Windows
Ok, I'll try that - thank you.
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
2,449
Office Version
  1. 365
Platform
  1. Windows
Good luck. There are tons of videos made by various 'instructors' if you're not fond of any particular one.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,223
Messages
5,768,902
Members
425,501
Latest member
sunderlalrwr

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
Top