473,320 Members | 1,940 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

HELP ~ How do I add a subform?

Hi,

I need to add a subform to an existing form that I have.

The issue is that I have only 1 table that houses all of the data I require to be in there. The main table has 25 fields and approx. 1000 records currently. Of those records some of the information is the same, for example I have multiple lines for 1 customer, I would like to design a form that will show their information that would remain static to that customer, and then a subform that wold have each order listed below that in relation to the customer.

I hope that makes sense.....is this possible? If so how do I do this, I attempted splitting the table and setting up relationships but am having a very hard time with that.

Any input would be greatly appreciated!!!

Thanks!!!
Nov 30 '06 #1
1 1036
MMcCarthy
14,534 Expert Mod 8TB
Hi,

I need to add a subform to an existing form that I have.

The issue is that I have only 1 table that houses all of the data I require to be in there. The main table has 25 fields and approx. 1000 records currently. Of those records some of the information is the same, for example I have multiple lines for 1 customer, I would like to design a form that will show their information that would remain static to that customer, and then a subform that wold have each order listed below that in relation to the customer.

I hope that makes sense.....is this possible? If so how do I do this, I attempted splitting the table and setting up relationships but am having a very hard time with that.

Any input would be greatly appreciated!!!

Thanks!!!
You cannot do this unless you normalise your table. That means, at least, creating a separate customer and order table.

Check out the 'Links to Useful Sites' thread near the top of the Access forum for a link on how to structure tables in access.
Dec 1 '06 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Earthling | last post by:
Any help would be appreciated to solve the following simple problem that I will describe. *** There is a form called "red chocolate form". The form has a particular subform field that has a...
3
by: radioman | last post by:
Hi all, I would appreciate some help please. I just need pointing in the right direction as I am at a loss. Basically I have a form (frmAddMaster) which displays two subforms "Master Stock...
3
by: Paul T. Rong | last post by:
I have a listbox (of product names) control on my form. I want to pass the selected item (a product name) to a subform, and the product unitprice should apear automatically next to the product name...
2
by: Paul T. RONG | last post by:
Hello there, I have a main form frmOrder and inside a subform sbfrmOrderDetail. When I add records from main form to subform, it is alright when the records don't exceed 40 rows (the subform's...
14
by: alwayshouston | last post by:
Hi All! I am working on this very small database and I am confused in the designing a simple form. I only have three tables in the database. First Table: tblExpense Columns: ExpenseID ;...
4
by: Elaine | last post by:
Hi I have created a form which contains a subform. To cut a long story short, I have created a macro that moves the focus to the subform (GoToControl) and sets a value (SetValue) in the field...
6
by: DP | last post by:
hi, i need a little help. i have two tables and 2 forms, one with a subform. i have a 'fildID' in one of the subforms, and i have another table, which has the film information, including a...
3
by: mcmahonb | last post by:
Hey people... I've been searching this forum for a few hours and even though this topic has been went over from many different angles; I cannot seem to figure out how to make things work on my...
3
by: kev | last post by:
Hello, I posted a question a while ago on tabbed pages, how to set it to invisible when the text box is empty.It was answered by Rick and the code ran perfectly. However, i tried using the same...
5
by: samdev | last post by:
I have created two combo boxes in a subform.... For example 1. Combo Box State 2. Combo Box City 3. When a state from the Combo Box State is selected, the City combo box updates to reflect...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.