fosterg100
New member
- Local time
- Yesterday, 19:49
- Joined
- Nov 29, 2019
- Messages
- 9
Hi
I am sure this is straightforward, just been going around in circles trying to figure this out.
I have a main form, with the main field being [REFERENCE], with this field being unique.
I just want a button on the main form to open a second form, that has the same field [REFERENCE], which will be a one to many relationship.
I am after the button to add a new record on the second form with the same field [Reference]
Have tried through code and queries, but nothing seems to work.
Can anyone point me in the right direction? Did a few databases a few years back, but this is the first one in a while.
Thanks in advance.
Foster.
I am sure this is straightforward, just been going around in circles trying to figure this out.
I have a main form, with the main field being [REFERENCE], with this field being unique.
I just want a button on the main form to open a second form, that has the same field [REFERENCE], which will be a one to many relationship.
I am after the button to add a new record on the second form with the same field [Reference]
Have tried through code and queries, but nothing seems to work.
Can anyone point me in the right direction? Did a few databases a few years back, but this is the first one in a while.
Thanks in advance.
Foster.