formatting form outputs

[pronate]

Hi all,

This is the output i have from a continous form, bound to a query, relating 2 tables.

Order No.| Customer | Items | Qty | Date-of-delivery
----------------------------------------------------
12214 | A001 | 1114-77 | 01 | 11-1-02
12214 | A001 | 1254-54 | 03 | 13-1-02
62541 | B021 | 45-545 | 01 | 10-1-02
52487 | G410 | 98-54 | 10 | 09-1-02

The first two records belong to the same order no. I wish the output can be this instead:

Order No.| Customer | Items | Qty | Date-of-delivery
----------------------------------------------------
12214 | A001 | 1114-77 | 01 | 11-1-02
| | 1254-54 | 03 | 13-1-02
62541 | B021 | 45-545 | 01 | 10-1-02
52487 | G410 | 98-54 | 10 | 09-1-02


Which is easier to read. Can it be? I can do this in reports but not forms.

Cheers
Sam

 

[mp9]

Maybe use a form with a sub-form on it? The main form would be bound to a table/query to provide OrderNo and Customer and the sub-form would be bound to a query that Items, Qty and DateOfDelivery. The form and sub-form would then be linked by OrderNo.

I don't know if this is appropraite for you but, with some careful formatting/sub-form positioning, it would certainly let you do what you want.

HTH.

http://www22.brinkster.com/accessory/