[AccessD] Form design question

I think you are talking about a continuous subform

The main form would contain the order number, order date etc
The subform would contain a line for each product, the quantity and
amount.

If you are looking at it for data entry, then you can use dropdown box
that links to product table to select the product, etc.

Hth
Patti

******************************************************************
*Patricia O'Connor
*Associate Computer Programmer Analyst
*OTDA - BDMA
*(W) mailto:Patricia.O'Connor at dfa.state.ny.us
*(w) mailto:aa1160 at dfa.state.ny.us
******************************************************************
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> accma at sympatico.ca
> Sent: Thursday, October 21, 2004 01:07 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Form design question
> 
> Hi all,
> 
> I'm wondering if it's possible to have multiple sections in a 
> forms like in a report.  I don't exactly know how to explane 
> this so I'll demontrate it as best as I can.  On a form, I 
> want to display all the products available.  That form would 
> be the order entry form.  What I would like to do is put 
> multiple column like this : product #, qt, price, product #, 
> qt, price, product #, qt, price.  The second and third 
> "product #, qt, price" would be the continuing of the first column.
> 
> Is this even possible and if so, how can I do this?
> 
> Tanks!
> 
> Annie
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>