Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-11-2019, 03:32 PM   #1
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 1,863
Thanks: 17
Thanked 353 Times in 350 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Add Linking records between master files

Several times I’ve seen basically the same question asked;
“I have a LIST and I want to show all of it, but only make linking records to those that apply?”
“How I do show all records in Table A and allow the user to link ONLY those records they want?”

Attached is a database that shows two approaches to “Show all of Table A and only those that link to Table B”. One is a subform that shows all from table A and a quantity applicable to the current record in table B, the other shows all from table A and has a separate form to show the links as children to Table B.

In the future I may work a bit more to make them more attractive / more functional, but for now the only “neat tricks” are to change the source for a combobox based on what Table A lists as values for use in the linking record and having big “+/-“ buttons for the products.
Attached Files
File Type: mdb Add Unrelated.mdb (484.0 KB, 94 views)

Mark_ is offline   Reply With Quote
The Following User Says Thank You to Mark_ For This Useful Post:
Uncle Gizmo (06-29-2019)
Reply

Tags
linking records

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking master field to sub fields chris@work Forms 4 12-19-2012 02:14 PM
De-linking master and child forms? Johnny Forms 1 04-12-2011 05:27 PM
Linking two databases via a master...?? virgosam20 General 13 07-03-2008 04:58 AM
Linking records to .doc, .pdf, .xls files simontindall General 1 12-07-2007 02:59 AM
[SOLVED] Export of Master and Subform to flat files jimbet7 Forms 1 12-07-2000 07:16 PM




All times are GMT -8. The time now is 09:27 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World