[AccessD] A2K: Basic Design Question

Hey Drew
Thanks for the reply
I tried that. But the most appropriate join shows a blank
record from tblOptions but does show the necessary ones from tblReminders


DD

----- Original Message ----- 
From: "Drew Wutka" <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, May 28, 2003 7:12 AM
Subject: RE: [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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com