subforrms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cynthia - 10 Apr 2006 23:55 GMT

I have a form that is continuous form that list all my cable types and
information.
for each reacord. I could have up to 72 different wires for each cable
type. I created a separate table that would hold the CableID from the first
table and then the entry for the Wire. How can I get this to show on the
line of the first form and allow the user to fill in multiple terminators. I
tried creating a form and pulling it in as a sub form but this did not work.
For one thing my subform will not allow entries?
It is a simple query as shown below
SELECT EleWires.CableID, EleWires.Wire FROM EleWires;

Reply to this Message

TC - 11 Apr 2006 07:37 GMT

Don't use a query.

Use the Relationships window to create a "one to many" relationship
FROM the CableID field in the first table, TO the same field in the
second table.

Then use the new form wizard to create a main form with a subform. The
main form is based on the first table. The subform is based on the
second table. The main form lets you view, add, edit or delete any
record from the first table. The subforms lets you view, add, edit or
delete the records from the second table, that relate to the record
that is currently displayed in the main form (from the first table).

HTH,
TC (MVP Access)
http:/tc2.atspace.com

Reply to this Message