Access - Subforms

[DBrown]

Novice here ... need help with creating a sub-form.

I have 2 tables and Forms

Main List Table, Event Table
Main List Form, Event Form

I am trying to create a 3rd form to reflect a sub-form
(Event Table) to (Main List Table).

Contacts in the Main List can attend multiple (many)
events.

When I go through the wizard it tell me I am "trying to
link field with incompatible data types". What difference
does it make?

Please Help

 

[Connie]

-----Original Message-----
Novice here ... need help with creating a sub-form.

I have 2 tables and Forms

Main List Table, Event Table
Main List Form, Event Form

I am trying to create a 3rd form to reflect a sub-form
(Event Table) to (Main List Table).

Contacts in the Main List can attend multiple (many)
events.

When I go through the wizard it tell me I am "trying to
link field with incompatible data types". What difference
does it make?

Please Help

.What is the field that is common to both tables? If

the "link" field is a number in one table and you made it
a text in the second table, that is why you can't link the
Child and Master field. So, first, what is the common
field between the two tables?

 

[chas]

Hi,

Access does not let you link fields that have different
datatypes. You must use the same type.

Text - Text
Number - Number

etc.......

hth

chas

 

[Wendi S.]

First, you may want to check to see if you used an autonumber in one
of your tables as the primary key. If you have, then the table that
you linked to (in this case, events) will need to have it's foreign
key be a long integer (number). This is the only way to link one
table to another that has an autonumbered primary key.

Let me know if that is the issue. Wendi S