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 |
#1
|
|||
|
|||
Table Design & Relationship problem...
Hi all, I'll try to explain as much as I can what I want to do.
I want an incoming notice paper to be in an access file along with some data... So we got one table with fields ( like sender,date,subject, etc.) that can take one-single value and another one (the Departement it belongs to) which can take multiple values (like IT,financial..blah). I want to make a form where we can enter all those information.So, I went and made that form with a subform that I made it to seek the values from the Deps table and made it multi-select.The thing is all wrong... I think I must have two tables with Department information.One which will have all the Deps and a form to edit that records and another one which will have the related notice papers and deps...But I don't know how to make that Hope someone can find the time to point me to the right direction..! |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Have you tried using the Wizard to make your subform for you? It is essential
that the two tables each have a field that is identical in both e.g. ID number. This will mean that the id number (if set up as Auto Number in your Main form) will be assigned to every entry you make in the subform. What is it that does not 'work' on your subform? "Niko" wrote: Hi all, I'll try to explain as much as I can what I want to do. I want an incoming notice paper to be in an access file along with some data... So we got one table with fields ( like sender,date,subject, etc.) that can take one-single value and another one (the Departement it belongs to) which can take multiple values (like IT,financial..blah). I want to make a form where we can enter all those information.So, I went and made that form with a subform that I made it to seek the values from the Deps table and made it multi-select.The thing is all wrong... I think I must have two tables with Department information.One which will have all the Deps and a form to edit that records and another one which will have the related notice papers and deps...But I don't know how to make that Hope someone can find the time to point me to the right direction..! |
#4
|
|||
|
|||
First of all I would like to thank you both Tim and Maria for your
time... I will try to make it more clear. We have two tables, one Paper which has related info(fields) like Sender,Date,Subject etc. and the second one Departments that has listed all the Departments of the company. Now, the employee must have a form to enter all the info for the Paper including the task to "assign" it to one or more Departments.That means that one Paper can belong to one or more Departments and one Department can have assigned many Papers.That is a many to many relationship, right? ( just read it! ) A detail I want to do is that a Paper cannot have in it's Department value the same Department twice. The problem I'm facing is that up to now I havent figured out a way to make the subform have a drop-down list of fixed values ( the Departments of the company ) and to update another table with the "assigned" Departments of one Paper. Waiting for your answers and...for the ideas to come into my head |
#5
|
|||
|
|||
|
#6
|
|||
|
|||
Well Tim,
just a few minutes after I posted my question I took a look at the Northwind db and found my solution just by seeing how the Orders, Order Details and Products tables interact... That's what I wanted to do! The problem is that I havent read a book about Access and I went straight on building a db! Tim thanks for your time I appreciate it.. |
#7
|
|||
|
|||
|
#8
|
|||
|
|||
Great post Tim!
Brett On Thu, 21 Oct 2004 14:18:22 -0700, Tim Ferguson wrote: (Niko) wrote in . com: That's what I wanted to do! The problem is that I havent read a book about Access and I went straight on building a db! Don't feel bad -- I hope I didn't sound as if I was putting you down. One of my big beefs with Access is the way that it's marketted as an end-user app. With Word, you can just fire it up and start typing, and more-or- less the same applies with Excel and Powerpoint (although it's easy to tell presentations that have been planned before hand!). Database design is very different, however, and you really need to have put in at least half[1] your design work before firing up Access for the first time. There is a significant knowledge base to absorb before you can do anything useful. It's nothing magic, but without it Access degenerates to merely a complex and frustrating cross between Cardfile and Sympbony. With some understanding of R theory, however, Access becomes a platform on which to create some really impressive and robust solutions. You'll find out how much fun that can be :-) All the best Tim F [1] Some sources say two-thirds or even up to 90%... Cheers, Brett ---------------------------------------------- Be adventurous, be bold, be careful, be a star ---------------------------------------------- Brett Collings Business & Systems Analyst Management Information Systems Developer |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Table design question - advice needed | David | Database Design | 3 | June 8th, 2004 02:21 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
Cannot join 1:M table into M:M tables | Tom | Database Design | 4 | May 19th, 2004 10:16 PM |