automatic row insert

[Jerry8989]

I would like to know if this is possible without using any code.



I have a form tied to table1. Within this form I have a button that opens another form which is tied to table2. Within the relationships I have id from table1 going to id for table2. My question is when I press the button on the form can I have it automatically add a row in table2 with the id from table1 that is currently tied to the form?

Say table1 has person info and table2 is the notes on this person
When I press the notes button for personid = 99 I want there to be a new
row added to table2 with id set equal to 99 without writing any insert statements or vba code.

Thank You

[RuralGuy]

Is this a test?

[Jerry8989]

What do you mean? It's a small work project

[RuralGuy]

What is the aversion to using code?

[Jerry8989]

Boss is a an oracle forms guy and thinks that is how it should work. I'm used to using VBA to do most things because I like to control how the app works. At previous job it was ok not here. LOL

[RuralGuy]

If it were a SubForm you could do it without code but as a separate form I guess you will need to have your boss show you how that is accomplished in Access.

[Jerry8989]

Rural,
That was my next plan was to ask him how he does it in oracle just to get an idea of how it's done.

Thank you

[RuralGuy]

It could be using a built in feature of Oracle that does not exist in Access. Good luck.