Add Linking records between master files (1 Viewer)

Status
Not open for further replies.

Mark_

Longboard on the internet
Local time
Today, 13:44
Joined
Sep 12, 2017
Messages
2,111
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.
 

Attachments

  • Add Unrelated.mdb
    484 KB · Views: 237
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom