I'm wondering if someone can help me. I'm pretty new to Access and
I'm having troubles linking tables and creating a subform. I have two
tables the primary table identifies calls. The secondary table
(subform) is a list of the coaches who would take these calls. I
believe this would be a "one to many" relation****p as there would be
one caller to many coaches. As a side note, the list for these
coaches will increase as we train more. Now these callers may have
more than one call. So the question I pose is this, does this mean
it's a junctional relation****p "many to many"? I have a link to the
main table based on a Call ID that is an autonumber with a long
integer. Can I Call ID in the second table that is also an autonumber
or does one have to be a number and the other a number or do both data
types must be the same? As I cannot enforce referential integrity.
Second issue, once I have the tables linked when I add my subform it
is not creating a drop down of all the coaches I have entered in the
subform. I am still having to enter each one, so they are not linking
properly. Please let me know if this makes any sense at all or if you
need more information. Thanks!
