Newbies Johnny Posted August 7, 2000 Newbies Share Posted August 7, 2000 I am working a db where each of fifty employees can work in up to three activities each day(out of a possible 1221 activities). What I would like to do is be able to obtain a list of the activity numbers worked each day. Anybody got a clue. Link to comment Share on other sites More sharing options...
LiveOak Posted August 17, 2000 Share Posted August 17, 2000 Need a little more information. What is a record in your database, what are the fields involved? - bd Link to comment Share on other sites More sharing options...
Vaughan Posted August 23, 2000 Share Posted August 23, 2000 Relational databases, one with employee name, other activities. Create a summary report in the activity file to get all the number out. Link to comment Share on other sites More sharing options...
Newbies Johnny Posted September 3, 2000 Author Newbies Share Posted September 3, 2000 Each record is one days work and one layout has 50 name fields, 50 emp. number fields, 150 activity numbers fields, 150 act. desciptions (lookup)fields, 150 hours fields, 50 total hours (calc)fields. Another layout has fields where I can type in the act. numbers I see that have been used that day then fields to accumulate the hours for each activity number I type in. What I was wondering was is there a way for FM to find the act. numbers for the day and put each one in a separate field without repeating so I would not manually have to find the numbers used each day. Link to comment Share on other sites More sharing options...
Vaughan Posted September 7, 2000 Share Posted September 7, 2000 OK, but I'll just say it again... you need to redesign your data model to use related databases instead of relying on 150 fields for everything. Once you go relational you'll realise how easy it will make everything... your problems will disappear because they are a result of a poor data model. Link to comment Share on other sites More sharing options...
Newbies Johnny Posted September 8, 2000 Author Newbies Share Posted September 8, 2000 Well, I agree that since I went relational several years ago that things went much easier and that this setup maybe poor db design. Thanks for your help. Johnny Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8639 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now