[AccessD] A2K: Basic Design Question

John Colby jcolby at colbyconsulting.com
Mon May 26 18:41:25 CDT 2003


How much info in this option table?  Can it go in a combo or list control?

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK
Sent: Monday, May 26, 2003 7:27 PM
To: AccessD List
Subject: [AccessD] A2K: Basic Design Question


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





More information about the AccessD mailing list