Trying to include subform/datasheet in continuous forms

[Garindan]

Hi all, I'm a bit stuck!

I'm building a form to show customer orders which haven't been delivered yet. I would like it to be continuous forms so that they can all be viewed at once.

The form uses qselUnprocessedPurchases which brings together qselCustomerDetails and qselCustomerPurchases.

qselCustomerDetails:-
CustomerNumber (PK)
Title
Name
Street
Area
Town
PhoneNumber
etc, etc

qselCustomerPurchases:-
PurchaseNumber (PK)
CustomerNumber
PurchaseDate_Time
TotalCost
DeliveryDate_Time

So having those in continuous forms is easy because its just displaying the purchase details and accompanying details of the customer. However, I also want to include the 'Purchased Items' in tblCustomerPurchasedItems, which holds products and quantities as follows:-

tblCustomerPurchasedItems:-
PurchasedItemID (PK)
PurchaseNumber
ProductID
Quantity

Obviously the problem is that each 'PurchaseNumber' in tblCustomerPurchases can include many different Products from tblCustomerPurchasedItems. This would normally be included as a simple datasheet subform linked to the PurchaseNumber, but since I want to have the main form as continuous forms it wont let me include a subform. So I'm unsure what to do? Can anyone help?

I cant make a query to include the Products can I? As there would be multiple entries for each PurchaseNumber rather than them being collected together.

Many many thanks for any help!

 

[Galaxiom]

Use a Listbox in the header or footer of the Continuous form.

Otherwise use two subforms. The Link Fields on one subform can be connected to a control on the main form. This control on the main form can have a control source as a field in the other subform.

 

[Garindan]

Hi Galaxiom, thankyou for your reply. I have decided to combine this with another thread I had so there's not too many. Would you be able to help me over there? I'm having real trouble with this
http://www.access-programmers.co.uk/forums/showthread.php?p=1040157