Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-21-2010, 07:17 AM   #1
cosmarchy
Newly Registered User
 
Join Date: Jan 2010
Posts: 63
Thanks: 2
Thanked 0 Times in 0 Posts
cosmarchy is on a distinguished road
Saving Data

Hello all,
I have a very frustrating problem, yet I am sure it is quite a simple one to answer.

I am building a database with two tables.
The first table holds information such as name, date, change number etc and the second table holds the actual change to the data itself, ie Qty, part number etc. There is a common field in both table (called change number) so that the many changes in the second table can be linked to a single in the first table ie it has a one-to-many relationship.

To represent the data I have a form and on that form I have a sub-form. The parent form has textboxes (which will be linked to the data in the first table) etc but in the sub-form I need a way of displaying a grid to enable me to enter data into the second table. At the moment the sub-form is a form made to look like a datasheet but the grid will not show until it is bound. The whole idea is that data is not entered into either of the tables unless it is saved, otherwise is should be discarded.

Does anyone have any advise please?

Thanks

cosmarchy is offline   Reply With Quote
Old 01-21-2010, 07:21 AM   #2
DCrake
Remembered
 
DCrake's Avatar
 
Join Date: Jun 2005
Location: Burnley, Lancashire
Posts: 8,634
Thanks: 8
Thanked 325 Times in 208 Posts
DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light
Send a message via Skype™ to DCrake
Re: Saving Data

The subform is the child of the mainform and as such in order to see the child records you first need to identify the parent record. That is why it appears blank.

Also you should not have orphans. Parents can be childless though.

David
__________________
David Crake


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
The Home of Simple Software Solutions.

O/S Windows XP (SP3) & Windows 7 64bit
Access 2003 (version 11.0)
Access 2007 (version 12.0)

Remember when posting sample databases you will get a better response if it is pre Access 2007 - not all people have it installed.
DCrake is offline   Reply With Quote
Old 01-21-2010, 08:21 AM   #3
cosmarchy
Newly Registered User
 
Join Date: Jan 2010
Posts: 63
Thanks: 2
Thanked 0 Times in 0 Posts
cosmarchy is on a distinguished road
Re: Saving Data

Quote:
Originally Posted by DCrake View Post
The subform is the child of the mainform and as such in order to see the child records you first need to identify the parent record. That is why it appears blank.

Also you should not have orphans. Parents can be childless though.

David
In that case how do I set up my tables? Are there any available tutorials - I cannot be the first to ask this, can I?

cosmarchy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Introduction to VBA Programming Banana Access FAQs 0 10-30-2008 06:11 PM
Using FindFast with SQL Table? jonno99 Modules & VBA 2 07-08-2005 01:31 PM
Refreshing a data entry form after saving data astarbyfar Forms 3 07-06-2005 11:25 PM
Subform Saving data from another Subform in a Survey Kila Forms 11 06-04-2003 12:07 PM
[SOLVED] How to make Pivot-like report with data in columns anicoll Reports 0 05-08-2003 12:52 PM




All times are GMT -8. The time now is 08:21 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World