add new record in form view

[Guest]

Dear Professional Access Users,

I have two linked tables (call them 'A' and 'B') and a form which shows and
allows to edit data from both. When I click to "add new record" button it
appends a new record to 'A' but I would like to make it appended to 'B' (I
have a different form to add data to 'A' - it is working). How can I add a
new record to 'B' using the form?

Thanks,

Peter

 

[Guest]

Most likely, you can't - easily.
To really help answer your question, it would be helpful to know something
about the data.
What is the relationship between A and B? If A is related to be in that A
is one to many to B, then you would use a subform control.
If A and B are one to one, then you may be able to use a query that joins
both tables as the form's record source; however, this is tricky and should
be avoided.
The other way is to use an unbound form and do all your data manipulation
programatically.

 

[Guest]

Dear Klatuu,

in the meantime I made some trial on my database. This problem occurs when I
set in the Properties/RecordSource a query. This is necessary to short the
records.
When I leave it simply as a table I can add new records.

The relationship between A and B is:
this is a music record database (LPs and CDs). A is Artists B is Discs.
Artists.artistID is related to Discs.artistID.
The sorting in query is: Artists.artistname, Discs.title.

Peter