Add new records

[slimjen]

All, using access 2016...I have a junction table with two FKIDs from two other tables to solve a m:m relationship...can I add new records to all three tables on one form without the user having to input ID info multiple times. If yes, how...I've tried using the junction table as the main form and subforms for the other tables but running into issues inputting data and getting data integrity errors since you cannot duplicate PKs in the subforms. I need to make it smooth for the users...

[mike60smart]

Hi

Can you upload a zipped copy of your Db so we can see the structure?

[slimjen]

No internet access for laptop right now..but I'll try to lay it out...tbl1 PK acentID, acent name, acent descrip, tbl2 PK procID, proc name, tbl3(junction tbl)
FK acentid, FK procID...Hope this is enough..

[davegri]

mtm One Form - davegri-v01.zip
This should to it. Have a look.

[mike60smart]

Hi

This works now

[davegri]

This works now

Mike, didn't see anything different in your rev except putting subform in single form view instead of datasheet.

Here's a rev that add code to the not-in-list event that allows user to add the events.
mtm One Form - davegri-v02.zip

Have a go at it too, if you wish.

[mike60smart]

What do you actually want to be able to do with this Form and Data Input ??

Please explain

[davegri]

What do you actually want to be able to do with this Form and Data Input ??

Perhaps you're confused. I'm not the OP.

[mike60smart]

Hi davegri

I am a little confused as the OP did not make any mention of a Not In List Event ??

His question was :-

"

• 
  
• All, using access 2016...I have a junction table with two FKIDs from two other tables to solve a m:m relationship...can I add new records to all three tables on one form without the user having to input ID info multiple times. If yes, how...I've tried using the junction table as the main form and subforms for the other tables but running into issues inputting data and getting data integrity errors since you cannot duplicate PKs in the subforms. I need to make it smooth for the users...
  
  
  
  
  Reply Reply With Quote
  
  
  
• Today, 04:45 PM
  #2
  
  
  
  

[ssanfu]

@slimjen

I strongly recommend that you DO NOT use spaces in object names.


BAD: (has spaces)
tbl1: acent name, acent descrip,
tbl2: proc name,


Better: (change spaces to underscores)
tbl1: Acent_Name, Acent_Descrip,
tbl2: Proc_Name,


Even Better: (CamelBack)
I would suggest using
tbl1: AcentName, AcentDescrip,
tbl2: ProcName,

[slimjen]

GM all; Thanks for all your replies. I apologize if I caused any confusion. I looked at the database attached. It is similar to was envision. Users need to be able to add new records to all three tables. Looking at this database gives me a few ideas. Thank you all very much.

[davegri]

Users need to be able to add new records to all three tables.

That was the idea in my second DB, in post #6.

Looking at this database gives me a few ideas. Thank you all very much.

You're welcome and good luck with the project.