G
Giem
Hey all,
I'm fairly new to database design, and have a problem with a query to add
new information into tables in Access 2003.
I have a repair table in which I am trying to add repair information, and at
the same time information to an RMA table that has RMA information. The
tables both have an "RMAID" field, which is an autonumber and is the primary
key in the RMA table. The repair table is the "many" side and the RMA table
is the "one" side. The RMA might have more than one repair tied to it. So far
nothing unusual from what I have seen in example databases.
I am trying, with a query, just to add a new record to a field in the REPAIR
table, and a field in the RMA table. Of course it won't let you unless you
add a new record in RMA inside the query first, then save the record, then
going back and add the REPAIR data in the record. I want to be able to add a
new record across tables at the same time without having to do this. That is,
I am trying to create a new RMA number every time I create a new repair.
Is there a way around this or is there some other methodology I should use
altogether?
I'm fairly new to database design, and have a problem with a query to add
new information into tables in Access 2003.
I have a repair table in which I am trying to add repair information, and at
the same time information to an RMA table that has RMA information. The
tables both have an "RMAID" field, which is an autonumber and is the primary
key in the RMA table. The repair table is the "many" side and the RMA table
is the "one" side. The RMA might have more than one repair tied to it. So far
nothing unusual from what I have seen in example databases.
I am trying, with a query, just to add a new record to a field in the REPAIR
table, and a field in the RMA table. Of course it won't let you unless you
add a new record in RMA inside the query first, then save the record, then
going back and add the REPAIR data in the record. I want to be able to add a
new record across tables at the same time without having to do this. That is,
I am trying to create a new RMA number every time I create a new repair.
Is there a way around this or is there some other methodology I should use
altogether?