[AccessD] A2K: Basic Design Question

On 27 May 2003 at 10:03, Darren DICK wrote:

> 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
> 

Create a subform based on tblOptions and put that in the footer of 
the form based on tblReminders

.


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.