Hi. I got around the problem I was having earlier (two tables in a form) by creating a query that included all fields from both the main and the sub-type tables, and based the form on the query instead of a table. Seems to work as I wanted. Sorry if you have already answered that but if you have an alternative solution I'll still try it.

I'm having another problem now however..

To the form I created, I have added a subform for yet another table. This table is in a 1:many relationship with the "main table".

This appears to work fine (it appears to be bound properly and data editing of the subform's contents updates the main table), but I would rather it appeared as a list, rather than as a mini-datasheet (I can't change the default colours/design).

Instead of a subform, I have tried adding a list box (based on the same table) to the form, but it doesn't appear to be bound properly - all the records of the table appear instead of just those that have the same value in the primary key field for the main form.

Any idea what I'm dribbling on about?

---

Answer from Richard Rost:

If you have a one-to-many relationship, then set up a form-subform relationship (not a listbox). You don't need to have the subform in DATASHEET view. Put it in FORM view. You can then change colors, positions of the controls, etc. This will also enforce your relationships (only show child records for the parent).