Hello All,
if i have a form, lets say for cutstomer and and a sub form for adding several orders for the same customer,
i have created a continuse sub form for the main form customer, which i think it is wrong .. .there is other correct way to design the sub form any one can advise.
Regards
How to design a sub form for data entry?
-
- 5StarLounger
- Posts: 1151
- Joined: 01 May 2016, 09:58
-
- NewLounger
- Posts: 8
- Joined: 16 Aug 2022, 05:39
Re: How to design a sub form for data entry?
From what you said it wouldn't seem wrong.
If you could see what you have accomplished it would be best, post a sample file on a data sharing site like Dropbox or something else.
If you could see what you have accomplished it would be best, post a sample file on a data sharing site like Dropbox or something else.
-
- Administrator
- Posts: 76156
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to design a sub form for data entry?
You can use a continuous subform based on the order table, and place it on the main form based on the customer table. I have often used such a design.
Here is a screenshot from a very old Northwind database:
Here is a screenshot from a very old Northwind database:
You do not have the required permissions to view the files attached to this post.
Regards,
Hans
Hans
-
- 5StarLounger
- Posts: 1151
- Joined: 01 May 2016, 09:58
Re: How to design a sub form for data entry?
Thank you very much