Solved

Main form and Sub forms

Posted on 2014-12-10
7
110 Views
Last Modified: 2014-12-10
Hello,

Could I do a Main form of my query that is based off one of my table and my table is the sub form..is this possible?
0
Comment
Question by:Jass Saini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 36

Expert Comment

by:PatHartman
ID: 40492041
You can but it doesn't make sense.  You are also likely to get conflict messages if you update data in one of the forms.  Sounds like your table design needs work.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40492068
I with Pat.

This is confusing...

Can you explain what you need here?

ex:
I have a query that displays _______________
I want to have a subform that displays ___________________
I need this because _______________________________
0
 

Author Comment

by:Jass Saini
ID: 40492108
So I am pulling a few fields from table1 and few from table2....parent/child linked by two common fields.

I can go through the records no problem and edit (input data ) into table2.

I don't want to go through all the records to find the hand full of records.  table1 is based on the names of the analyst and I want to pull only those records for that analyst based on the two common fields.
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40492142
You can do this , ...but I am still confused by your statement:
"parent/child linked by two common fields."

Typically a Part/Child is linked by *one* common field
tblCustomers.CustomerID--> tblOrders.CustomerID

So in your case you can make the main query the main form "Analysts"  (with a PK of perhaps AnalystID)
then create a subform form the "AlaylstRecords" table (whatever that means), ...again based on the foreign key of AnalystID...
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 40492161
something like this:
Database1x.mdb
0
 

Author Closing Comment

by:Jass Saini
ID: 40492176
Thanks this will work because I already have a tbl with all the analyst names
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40492793
ok
;-)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question