Arthur Fuller
fuller.artful at gmail.com
Thu Aug 25 06:54:34 CDT 2011
It's not clear whether he wants to combine the two sub-tables in a single grid or display them separately. If the latter, my choice would be to create a tabbed form with one subtable on each tab, or for a side-by-side display, create a blank subform and then a pair of sub-subforms, one addressing each subtable, and lay them out side by side. HTH, Arthur On Thu, Aug 25, 2011 at 5:33 AM, Martin <martinreid at gmail.com> wrote: > Its not mine (<: One of our staff asked. I am in middle of major upgrade to > sharepoint 2010 as I have mostlymoved of access. > > here is his question > > > 1. The best help I could receive from you would be if you created a > new database with a main form based on one table with one primary key RICID > and one other field, together with a subform based on two tables, each with > two primary keys one being RICID and the other DATE. Each subform table > can > have one other field. > >