If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
How to create
Steve,
Now I understand the matter. Thanks a lot lot. ------------------------------------------------------------------- "Steve Schapel" wrote: Kutty, Thanks for the further explanation. You will see a 'plus' sign in the table datasheet if: - the relationship between the tables is defined under Tools|Relationships menu from the main database window, and - the table's 'Subdatasheet Name' property is set to an appropriate setting. Creating a join between the tables in a query does not have the same effect. In the case of your example, where the Departments field only has one field for Department, and this is matched to the data in the Department field in the Employees table, the Departments table is very handy for the purpose of a combobox list for the data entry of the Department for the Employees. But there will probably never be any reason to make a query that involves both tables, as this will not achieve any purpose. Hope that helps to clarify the situation. -- Steve Schapel, Microsoft Access MVP Kutty wrote: Steve, I meant by "not connected" is : I went to queries design. I dragged Department field from Departments Table to Department field of Employees Table. This is what I meant by connection. Once we connect this way and check in table we can see plus sign in each record. I cannot see this plus sign. That is why I thought not connected one field to another field. Did you understand now? |
#12
|
|||
|
|||
How to create
Steve,
Now I can see a plus sign in table data sheet after I have done as you told. You mentioned "Creating a join between the tables in a query does not have the same effect". I have misconcept about joining between the tables in query. What is the advantage of joining tables in query? What is the difference of joining from Tools|Relationships menu from the main database window and Creating a join between the tables in query ? I understand from reply from you that I can create a combo box in Employees table. Please tell me what is your openion about creating tab control too ? Please reply to me. ------------------------------------------------------------------------------------------ "Steve Schapel" wrote: Kutty, Thanks for the further explanation. You will see a 'plus' sign in the table datasheet if: - the relationship between the tables is defined under Tools|Relationships menu from the main database window, and - the table's 'Subdatasheet Name' property is set to an appropriate setting. Creating a join between the tables in a query does not have the same effect. In the case of your example, where the Departments field only has one field for Department, and this is matched to the data in the Department field in the Employees table, the Departments table is very handy for the purpose of a combobox list for the data entry of the Department for the Employees. But there will probably never be any reason to make a query that involves both tables, as this will not achieve any purpose. Hope that helps to clarify the situation. -- Steve Schapel, Microsoft Access MVP Kutty wrote: Steve, I meant by "not connected" is : I went to queries design. I dragged Department field from Departments Table to Department field of Employees Table. This is what I meant by connection. Once we connect this way and check in table we can see plus sign in each record. I cannot see this plus sign. That is why I thought not connected one field to another field. Did you understand now? |
#13
|
|||
|
|||
How to create
Steve,
I am going to develop a report also for this contact database. Once my boss ask me to give him single or multiple person's name and contact number I have to give him the report. Depends on my boss's requirement, can I put specific employees contact list with a one click or two click? I hope you got what I mean. ------------------------------------------------------------------------------------------- "Steve Schapel" wrote: Kutty, Thanks for the further explanation. You will see a 'plus' sign in the table datasheet if: - the relationship between the tables is defined under Tools|Relationships menu from the main database window, and - the table's 'Subdatasheet Name' property is set to an appropriate setting. Creating a join between the tables in a query does not have the same effect. In the case of your example, where the Departments field only has one field for Department, and this is matched to the data in the Department field in the Employees table, the Departments table is very handy for the purpose of a combobox list for the data entry of the Department for the Employees. But there will probably never be any reason to make a query that involves both tables, as this will not achieve any purpose. Hope that helps to clarify the situation. -- Steve Schapel, Microsoft Access MVP Kutty wrote: Steve, I meant by "not connected" is : I went to queries design. I dragged Department field from Departments Table to Department field of Employees Table. This is what I meant by connection. Once we connect this way and check in table we can see plus sign in each record. I cannot see this plus sign. That is why I thought not connected one field to another field. Did you understand now? |
#14
|
|||
|
|||
How to create
For report : I have got an idea. Let me put an extra colum in employee table.
For example, If I need to print 3 persons contact number I have to click in 3 new colums to print 3 records. Can I do this way? How to do? Waiting for your reply. -------------------------------------------------------------------------------------------- "Steve Schapel" wrote: Kutty, Yes, you can make the Department field the Primary Key of the Departments table. -- Steve Schapel, Microsoft Access MVP Kutty wrote: Steve, Shall I key primary key for Departments Table? --------------------------------------------------------------- |
#15
|
|||
|
|||
How to create
Kutty,
I did not suggest to create a combobox in the Employees table. In general, tables should not be used for data entry/manipulation, and normally should not be seen by the user. Their purpose is data storage, so this kind of data entry functionality is not necessary. I was referring to using a combobox on a form. Relationships as defined in the Relationships window, and joins in queries, are for two different purposes. You define Relationships in order to enforce Referential Integrity. In the example we have been discussing, this would mean that the database will not allow you to assign a Department to an Employee if that Department does not exist in the Departments table. On the other hand, in a query based on more than one table, the purpose of the Join is to cause the query to return records where the data in the joined fields matches. Of course, it often happens that the Join in a query is the same as the Relationship betwen the tables. But it is not uncommon for queries to involve joins between tables that are not involved in defined Relationships. The main reason for using a Tab Control on a form is to make the layout of the data more user-friendly, or because there is too much information required on the form to be comfortably accommodated on one screen. -- Steve Schapel, Microsoft Access MVP Kutty wrote: Steve, Now I can see a plus sign in table data sheet after I have done as you told. You mentioned "Creating a join between the tables in a query does not have the same effect". I have misconcept about joining between the tables in query. What is the advantage of joining tables in query? What is the difference of joining from Tools|Relationships menu from the main database window and Creating a join between the tables in query ? I understand from reply from you that I can create a combo box in Employees table. Please tell me what is your openion about creating tab control too ? Please reply to me. ------------------------------------------------------------------------------------------ |
#16
|
|||
|
|||
How to create
Kutty,
Yes, this will work, and this type of approach is often followed. You can make it a Yes/No data type field, and have it represented on your form by a checkbox, and then you can just select the employees that you want included in the report. -- Steve Schapel, Microsoft Access MVP Kutty wrote: For report : I have got an idea. Let me put an extra colum in employee table. For example, If I need to print 3 persons contact number I have to click in 3 new colums to print 3 records. Can I do this way? How to do? Waiting for your reply. -------------------------------------------------------------------------------------------- |
#17
|
|||
|
|||
How to create
Steve,
Actually I have to tell you tha I have to put an extra control in employee form, not table. Sorry for the mistake. My idea is how many records I have to print that much records I have to select by clicking. After click that much records have to print. Can I do this? Please tell me how to do this. --------------------------------------------------------------------------------------- "Kutty" wrote: For report : I have got an idea. Let me put an extra colum in employee table. For example, If I need to print 3 persons contact number I have to click in 3 new colums to print 3 records. Can I do this way? How to do? Waiting for your reply. -------------------------------------------------------------------------------------------- "Steve Schapel" wrote: Kutty, Yes, you can make the Department field the Primary Key of the Departments table. -- Steve Schapel, Microsoft Access MVP Kutty wrote: Steve, Shall I key primary key for Departments Table? --------------------------------------------------------------- |
#18
|
|||
|
|||
How to create
Kutty,
Just tick the checkbox on the form for each employee you want included in the report. Then, in the query that the report is based on, you would put a Criteria of -1 in this Yes/No field, so only those Employees whose checkbox is ticked will be shown on the report. -- Steve Schapel, Microsoft Access MVP Kutty wrote: Steve, Actually I have to tell you tha I have to put an extra control in employee form, not table. Sorry for the mistake. My idea is how many records I have to print that much records I have to select by clicking. After click that much records have to print. Can I do this? Please tell me how to do this. --------------------------------------------------------------------------------------- |
#19
|
|||
|
|||
How to create
Steve,
Let me know how to arrange combo box on the Employee Form. In Department I have Sales, Contract, Marketing and so on. I have inserted combo box of Department field. But when I click Combo Box I can get multiple Sales Department, multiple Marketing I get. That should be unique. When I check in Table the Departments are there with plus sign. How can I get departments as unique fields in my Combo Box? In the same time I find the Department field in form without Combo Box unique. Please comment. If this is not clear for you please inform me. I will explain again. --------------------------------------------------------------- "Steve Schapel" wrote: Kutty, Just tick the checkbox on the form for each employee you want included in the report. Then, in the query that the report is based on, you would put a Criteria of -1 in this Yes/No field, so only those Employees whose checkbox is ticked will be shown on the report. -- Steve Schapel, Microsoft Access MVP Kutty wrote: Steve, Actually I have to tell you tha I have to put an extra control in employee form, not table. Sorry for the mistake. My idea is how many records I have to print that much records I have to select by clicking. After click that much records have to print. Can I do this? Please tell me how to do this. --------------------------------------------------------------------------------------- |
#20
|
|||
|
|||
How to create
Steve,
Thanks for explaining how to print report as follows. But I don't know how to do that. Could you please inform me in details? Would appreciate your great favor. --------------------------------------------------------------------------------------------- "Steve Schapel" wrote: Kutty, Just tick the checkbox on the form for each employee you want included in the report. Then, in the query that the report is based on, you would put a Criteria of -1 in this Yes/No field, so only those Employees whose checkbox is ticked will be shown on the report. -- Steve Schapel, Microsoft Access MVP Kutty wrote: Steve, Actually I have to tell you tha I have to put an extra control in employee form, not table. Sorry for the mistake. My idea is how many records I have to print that much records I have to select by clicking. After click that much records have to print. Can I do this? Please tell me how to do this. --------------------------------------------------------------------------------------- |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't create dynamic charts | Brian Sells | Charts and Charting | 7 | March 22nd, 2005 04:23 AM |
Can't Create MDE | Hatman | General Discussion | 1 | March 19th, 2005 05:42 PM |
Template in Excel | prettytwin1 | New Users | 1 | March 9th, 2005 09:22 PM |
Need help: Can't create ADP Database in MSDE from MS Access | Lou Arnold | General Discussion | 0 | July 21st, 2004 04:54 AM |