[AccessD] A2K: Basic Design Question

Hi Susan
Thanks for the reply
tblReminders has hundreds of records in it with about 7 or 8 fields.
tblOptions will only ever have 1 record in it with about 5 or 6 fields.

Nothing in tblOptions relates to anything in tbleReminders.
tblReminders has date, time, YesNo flags and text fields that hold info about appointments.

tblOptions has similar fields but hold local settings info eg how long a timer interval is
the path for various logos, paths for sound files etc. There will only ever be one record in this
table

Thanks again

Darren




----- Original Message ----- 
From: "Susan Harkins" <harkins at iglou.com>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, May 27, 2003 9:40 AM
Subject: Re: [AccessD] A2K: Basic Design Question


> You're specifying these options for each record in the continuous form?  If
> that's the case, why not just base the form on a multi-table query? I
> probably don't understand the question. :)
> 
> Susan H.
> 
> 
> > Hello all
> >  I have a continuous form that has varying recordsets.
> > Pretty much the same data but with things like...
> > Show for a Date or a Date Range Show for Completed/ Not Completed
> > Show for Future/Past/Next week etc etc. All held in tblReminders
> >
> > I have a set of options all held in tblOptions.
> > I want the settings kept in the options table to be presented to the user
> in the
> > footer of the continuous form. But I can't get the 2 together because they
> have
> > no matching record. I can't put the options in a sub form because you
> can't have
> > a sub form in a continuous form.
> > I though about a union query but that means I would have to manage all the
> > current RecordSet setting in pure SQL  - I'm not good enough for that.
> >
> > Anyway how do you guys handle these situations?
> >
> > Many thanks in advance
> >
> > Darren
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com