Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Adding fields from different tables to the same form without error
Started 1 month, 1 week ago by NC24
I have a database with 4 tables that have a one-to-many relationship. These tables all have a primary key and foreign keys. When I add fields from two different tables onto a form and look at the form in form view, the fields disappear. Previously when adding fields from other tables to a form, a wizard box pops up asking how these tables are related. This, however, has not happened when I try to...
Site: Access World Forums  Access World Forums - site profile
Forum: Forms  Forms - forum profile
Total authors: 3 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: access-programmers.co.uk

Other posts in this thread:

Kryst51 replied 1 month, 1 week ago
Use a subform... for the relateds, or you could try a list box.
Size: 63 bytes
Customize:  Customize "<b>Reply 1</b>: Adding fields from different tables to the same form without error :: Forms :: Access World Forums"

Kryst51 replied 1 month, 1 week ago
I don't think a form can show a one to many as is, without the subform or a list box, it's just not capable of working that way.
Size: 128 bytes
Customize:  Customize "<b>Reply 2</b>: Adding fields from different tables to the same form without error :: Forms :: Access World Forums"

NC24 replied 1 month, 1 week ago
I'll try that, thanks!
Size: 22 bytes
Customize:  Customize "<b>Reply 3</b>: Adding fields from different tables to the same form without error :: Forms :: Access World Forums"

Kryst51 replied 1 month, 1 week ago
Your Welcome. Let us know if it works!
Size: 38 bytes
Customize:  Customize "<b>Reply 4</b>: Adding fields from different tables to the same form without error :: Forms :: Access World Forums"

 

Top contributing authors

Name
Posts
Kryst51
3
user's latest post:
Adding fields from different...
Published (2009-11-10 08:29:00)
Your Welcome. Let us know if it works!
NC24
2
user's latest post:
Adding fields from different...
Published (2009-11-10 08:28:00)
I'll try that, thanks!
NC24 Registered User
2
user's latest post:
Adding fields from different...
Published (2009-11-10 08:28:00)
I'll try that, thanks!

Related threads on "Access World Forums":

Newbie question - adding fields? tables?  Access World Forums - site profile Reports - forum profile Newbie question - adding fields? tables?
Newbie question - adding fields? tables?
Adding fields in tables  Access World Forums - site profile Queries - forum profile Adding fields in tables
Adding fields in tables
Adding fields to a query that aren't in the tables...  Access World Forums - site profile Tables - forum profile Adding fields to a query that aren't in the tables (Access 2003)
Adding fields to a query that aren't in the tables (Access 2003)
Adding fields based on values in other fields  Access World Forums - site profile General - forum profile Adding fields based on values in other fields
Adding fields based on values in other fields
Adding fields in a table  Access World Forums - site profile DeVoteD - forum profile Adding fields in a table
Adding fields in a table
Adding fields values together !  Access World Forums - site profile Forms - forum profile Adding fields values together !
Adding fields values together !
Adding fields between report and subreport  Access World Forums - site profile Reports - forum profile Adding fields between report and subreport
Adding fields between report and subreport
Adding Fields to PivotChart  Access World Forums - site profile Modules & VBA - forum profile Adding Fields to PivotChart
Adding Fields to PivotChart
Adding Fields  Access World Forums - site profile Forms - forum profile Adding Fields
Adding Fields
Auto adding fields in datasheet view?  Access World Forums - site profile Tables - forum profile Auto adding fields in datasheet view?
Auto adding fields in datasheet view?

Related threads on other sites:

[Forms] Adding fields from different tables onto the same...  ASP Free Forums - ASP Help, ASP Tutorials, ASP Programming, ASP Code, ASPHosting - site profile Microsoft Access Help - forum profile [Forms] Adding fields from different tables onto the same form without error
[Forms] Adding fields from different tables onto the same form without error
Adding of Tables/Fields in FI Substitituiton GGB1  SAPFans - site profile ABAP - forum profile Adding of Tables/Fields in FI Substitituiton GGB1
Adding of Tables/Fields in FI Substitituiton GGB1
Adding fields to existing tables in microsoft.public.axapta  Discussions in microsoft.public.axapta - site profile microsoft.public.axapta - forum profile Adding fields to existing tables in microsoft.public.axapta
Adding fields to existing tables in microsoft.public.axapta
Adding Fields to Linked Tables  MCSE braindumps - site profile Access General - forum profile Adding Fields to Linked Tables
Adding Fields to Linked Tables
Dangers of Adding fields to Database Tables: There are...  Twitter / hurricanesoft - site profile hurricanesoft - forum profile Dangers of Adding fields to Database Tables: There are certain dangers if you don&#8217;t plan carefully before .. http://tinyurl.com/d8upjd 1:21 AM Feb 19th from web
Dangers of Adding fields to Database Tables: There are certain dangers if you don&#8217;t plan carefully before .. http://tinyurl.com/d8upjd 1:21 AM Feb 19th from web
Adding fields to your wp tables and upgrading  WordPress Support - site profile Plugins and Hacks - forum profile Adding fields to your wp tables and upgrading
Adding fields to your wp tables and upgrading
Error in adding fields to a page  Iron Speed - site profile Using Iron Speed Designer V4.X - forum profile Error in adding fields to a page
Error in adding fields to a page
Is adding more required fields and error checking to this...  Twitter / skullranch - site profile skullranch - forum profile Is adding more required fields and error checking to this damn PHP mail form... Wish me luck! 8:09 AM Mar 25th from web
Is adding more required fields and error checking to this damn PHP mail form... Wish me luck! 8:09 AM Mar 25th from web
Mysqldump and 'select *' fail on tables with BLOB and...  MySQL AB - MySQL Forums - site profile Cluster - forum profile Mysqldump and 'select *' fail on tables with BLOB and TEXT fields (Got error 4350 'Transaction already aborted' from NDBCLUSTER)
Mysqldump and 'select *' fail on tables with BLOB and TEXT fields (Got error 4350 'Transaction already aborted' from NDBCLUSTER)
Error adding fields from form 2.6.1.8  http://www.websitebaker.org - site profile Website Baker 2 - forum profile Error adding fields from form 2.6.1.8
Error adding fields from form 2.6.1.8
Thread profile page for "Adding fields from different tables to the same form without error" on http://www.access-programmers.co.uk. This report page is a snippet summary view from a single thread "Adding fields from different tables to the same form without error", located on the Message Board at http://www.access-programmers.co.uk. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity