concatenating within a table field

[papa jonah]

I am using several forms to capture data of several types. Of course,
I have underlying tables for each form. However, there is some
"binning" information that is common to each of the forms that I want
to capture in a subform that will store the "common" types of data in a
seperate form.

My problem is that each of the underlying tables, for example "tblHome"
and "tblAuto" are using autonumbers to generate a primary key for the
tables. As a result tblHome and tblAuto both share a record designator
"1" and "2" etc. In order to allow the common "binning" table to
differentiate between the parent tables, I thought I would add another
field to each of the parent tables and have a default value (that is
not visible on their respective forms) such as "House" for the tblHome,
or "auto" for the tblAuto.
My thinking is that I could somehow concatenate the autonumber from
each record with the value of house or auto (depending on the
appropriate table). Then my primary key values would look something
like:
house1
house2
house3, etc or
auto1
auto2
auto3 etc.
Then I think my child binning table will be able to properly relate the
info to the correct parent tables.
Does that sound right? If so, how would I concatenate within a field?

TIA

 

[Guest]

that will store the "common" types of data in a seperate form.
Forms do not store data.

how would I concatenate within a field?

You do not concatenate in a field. You can concatenate in a query, form, or
report.

In what way do you want to relate the House and Auto tables?

What is this 'child' table you mentioned? What would it contain?