[AccessD] A2K: Basic Design Question

Hmmm, just off hand, to be simple on this, just add a field to both tables
and set it's default value to 1.  Then you can 'join' the tables on that
field.

Drew

-----Original Message-----
From: Darren DICK [mailto:d.dick at uws.edu.au]
Sent: Monday, May 26, 2003 7:03 PM
To: accessd at databaseadvisors.com
Subject: Re: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com