473,323 Members | 1,537 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,323 software developers and data experts.

Main form to have multiple subforms for data entry

16
I have a main form to record the members detail, i have to assign multiple values for their products and production as
one member can produce
1-Mad ups
2-Bedwear
3- garments
or 3 of them
similarly could have in house manufacturing facilities like
1-dying/processing
2-weaving
3-cutting
4-stitching
or 4 of them
how can i implement this information in members main form?
creating junction table then how to manage two sub-forms?
i am not considering Multi-valued fields for this, though ready made solution :)
hope for some great response :)
Dec 15 '15 #1
3 1350
zmbd
5,501 Expert Mod 4TB
Your question is really unclear.
You have provided no relationship information between the example data; thus, it's difficult to determine if you really need two subforms or a single subform based on the M:M table.
Dec 17 '15 #2
RaoAli
16
thank You for the response :)
There are tables like this

members table
MemberID
Adress
contact

Process Table Member_Process_JunctionTable
ProcessID MemberID
ProcessDetail ProcessID

ProductTable Member_Product_juncitonTable

ProductID MemberId
ProducatName ProductId

Now in Member's forms junction tables must be implemented to so that number of options for product and process can be selected. Every member can have more than more product and process.
hope I manage to make my point clear.
Dec 18 '15 #3
zmbd
5,501 Expert Mod 4TB
Let's take a look at:
ProcessDetail ProcessID
and
ProducatName ProductId


Can more than one ProcessID be associated with a ProductId (or the otherwayaround :) )?
If true then (I'm omitting type-casts here :) ):
tbl_MM_Member_Process_Product
[PK]; [fk_memberID]; [fk_ProcessID]; [fk_ProductID]
create a compound table key based on the three foreign keys and set the value to unique; thus preventing something like:
old record:[1][1][1][1]
attempted new record:[233][1][1][1]
[PK]=233 would be rejected because member 1, already has process 1 and product 1 associated with that process in [PK]=1.

Parent on the members table
Child based on tbl_MM_Member_Process_Product table - linked on memberid


Otherwise
Parent on the members table
Child n the process join table - linked on memberid
Child two on the products join table - linked on memberid

Both child tables will have to have a means of preventing duplicate entries, unless that's something you desire(?!) such as the compound key. I don't see a primary key in your examples, you can use the compound; however, mind you, I rarely use a compound key as the primary key - but that's personal choice.

In either of the above cases (single child or two)...
I personally would use a combobox in each table to show the available options for product and processes respectively. The row sources can be setup to show all options or only un-assigned options.
Dec 18 '15 #4

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

Similar topics

2
by: David Pautler | last post by:
I'm creating a web-based authoring tool where one form encompasses several sections for editing. I'd like each section to have its own reset button, so that use of that button affects only that...
4
by: Bob | last post by:
I'm running Access 97 and have a sub-form within a main form. The subform allows data entry by the user. Now, I would also like to enter a row from a macro, but when I try, the entry always goes...
2
by: Reginald Bal | last post by:
Hello, I created a main form with 2 subforms. In an attempt to move to the next record (or new record) on the main form I get the error " Method 'requery' of object '_Subform' failed". The...
4
by: microb0x | last post by:
I have an application with a master form with a tab control containing nine tabs, each tab contains a subform. I have command buttons on my main form including: Save , Cancel , Close. My...
9
by: Ecohouse | last post by:
I have a main form with two subforms. The first subform relates to the main form using an identity key (this works). The second subform relates to both the main and first subform. But I want to...
3
by: BASSPU03 | last post by:
My "View All Resources" code is no longer fully suitable for its respective DB form. Now it's not a matter of just opening one form and making it read-only. Now I have a main form with three...
0
by: TD | last post by:
I have a main form with two subforms (both in datasheet view), neither of which are linked to the main form. The main form is based on a query that uses the bound column of a combobox on the main...
1
by: c0l0nelFlagg | last post by:
I need to display a main form with 48 identical subforms. 6 columns with 8 rows. I set up a separate query for each subform, identical in structure and underlying data except the criteria in...
1
by: ncsthbell | last post by:
I am using MS access 2007. I want to create a form that when opened will contain all blank columns (to do this I believe I do not include a record source on the forms property). I want the user to...
2
by: hokey | last post by:
My data form is no longer moving to the new record once data entry for one form is complete since I added an extra couple of fields. How can I ensure it moves to a new record once data entry is...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...
1
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
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.