Users table fixed and adding lines keeping the same contact information.

[arturgoncalves]

Hello Everybody!

I read some posts and I have noticed that this was the best web site for information.

This is why I have a question..

I'm creating a form that is linked to some different tables. I need now to make the users chosen remains until I finish adding the tasks that the user completed and when I hit the save button, everything needs to be saved and a black page needs to be open.

Any ideas? I attached my project if someone wants to see what have been done

Thank you,

Artur

 

[jdraw]

What is your database about?
How would you describe your database -purpose, things involved etc in 5 or 6 lines?

 

[arturgoncalves]

Thank you for replaying jdraw.

My database consists of:
Contacts, difficulty, numbers, and tasks table.

My main Idea is to save for example everyone that works for a group, this information will consist of the contacts information. For each contact, the Numbers form will be the place that everyone can select its own name and add some tasks that they have completed, date, difficulty level, and the quantity of items of that specific task.

My problem right now is with the "Numbers Form". I'm trying to fix the contacts information while I'm adding tasks, which would be adding multiple lines to my database with the same contact.

Is that clear? I don't know if it is clear. lol

 

[jdraw]

Getting your tables designed to meet your requirements is very important with database applications. If your tables and relationships do not support your business, you will continually be using "work arounds" in an attempt to make things work. Get the tables and relationships designed and tested (with test scenarios) before getting into forms etc.

Here is a description of an application.

Narrative
ZYX Laboratories requires an employee tracking database. They want to track information about employees, the employee's job history, and their certifications. Employee information includes first name, middle initial, last name, social security number, address, city, state, zip, home phone, cell phone, email address. Job history would include job title, job description, pay grade, pay range, salary, and date of promotion. For certifications, they want certification type and date achieved.
An employee can have multiple jobs over time, (ie, Analyst, Sr. Analyst, QA Administrator). Employees can also earn certifications necessary for their job.

There is a tutorial associated with this narrative here.

 

[arturgoncalves]

Thank you! I have started doing it, but this is why I still have some problems! I think you might be able to see my file now.