Two tables one form

  • Thread starter Thread starter MARK C via AccessMonster.com
  • Start date Start date
M

MARK C via AccessMonster.com

I'm a novice at this so please bear with me. I have a table that contains
the customer name, number, and address fields. I would like to access this
data in a form by searching on the customer name. Once the data is populated
in the form, I would like to enter additional data into the form via a date
delivered and time delivered field, then save all of the fields to a new
table called deliveries. I'm sure there is an easy way of doing this.
 
Hi,


Have you tried to use a query as recordsource for your form? a query can
"join" two tables. Make sure the query is updateable (in query-data-view)
before building the form over it.


Hoping it may help,
Vanderghast, Access MVP
 
Hi Michel,

I am new to Access and I have the same problem. Is there a URL that shows me
how to do this in more detail? If not, can you provide a little more detail?
Should I use Expression Builder, Macro, or VB Code?

Any help or redirection is appreciated.

Thanks,
--Paul

Michel Walsh said:
Hi,


Have you tried to use a query as recordsource for your form? a query can
"join" two tables. Make sure the query is updateable (in query-data-view)
before building the form over it.


Hoping it may help,
Vanderghast, Access MVP
Click to expand...
 
Hi,

You should create a new query. You bring the two involved tables, and draw a
join between them (someone can see a join like a lookup) on fields to match
(customerID, probably). Next, you bring the required fields in the grid and
test that you have all what you need AND that you can update the data
switching from the design view into the data view.

When this query works, you save it, and you build your form on that query
(rather than on one table).


There is no other "magic" involved, than that... :-)


Hoping it may help,
Vanderghast, Access MVP


paul_p_francis said:
Hi Michel,

I am new to Access and I have the same problem. Is there a URL that shows
me
how to do this in more detail? If not, can you provide a little more
detail?
Should I use Expression Builder, Macro, or VB Code?

Any help or redirection is appreciated.

Thanks,
--Paul
Click to expand...
 
That worked! Thanks Michel.

Michel Walsh said:
Hi,

You should create a new query. You bring the two involved tables, and draw a
join between them (someone can see a join like a lookup) on fields to match
(customerID, probably). Next, you bring the required fields in the grid and
test that you have all what you need AND that you can update the data
switching from the design view into the data view.

When this query works, you save it, and you build your form on that query
(rather than on one table).


There is no other "magic" involved, than that... :-)


Hoping it may help,
Vanderghast, Access MVP
Click to expand...
 
Back
Top