Inputting same data on identical Field Name on different table
0
votes
1
answer
440
views
currently i am new in ms access,
And currently - as a trial and learning step - I created Two tables, and a Single Form that can be used to put a value to both tables, those are:
**Table 1** - "Data 1", the Fields are:
ID, RegDates, CatName1, CatName2
**Table 2** - "Data 2"
ID, RegDates, DogName1, DogName2
**Form 1** - "Input Form"
ID
Registration Dates
CatName1
CatName2
DogName1
DogName2
I can't populate ID on both tables using Relationships, but I cant populate nor filling RegDate fields on both Tables using one single "Registration Date" Form on Input Form
How can I achieve filling both Field Name - which is RegDate - using only one single Input textbox on "Input Form"?
What I want is, If I entry the Registration Date on "Input Form" Both regDate field on Data 1 and Data 2 are filled
Thanks!
Asked by Idad
(1 rep)
Feb 18, 2022, 10:29 PM
Last activity: Feb 12, 2025, 02:08 AM
Last activity: Feb 12, 2025, 02:08 AM