Single Table used for Multiple Forms

[shieriel]

Please help me on my project.

I created a table based on 3 different processes, all the required data from process A, process B, and Process C are combined in a single table. Then i created Forms each for every process wherein the data are those selected fields from the Table. Is this really possible? Because when i tried to enter data on my form i cannot proceed to add the records and it always having an error of "You cannot go to specified record."
What should i do? Do i have to create different tables for each pocesses? But the purpose i created a single table is that there are some fields that are related or same as the all other processes.

 

[boblarson]

how about posting a copy of your database so we can see what you currently have?

 

[shieriel]

Hi Sir,
My file is 2.2mb which is beyond the allowable limit on this forum, therefore you may download it through the link provided below.

http://www.mediafire.com/file/zwjaihmxynf/changeover.zip


Thanks.

 

[shieriel]

Please help me on my project.

I created a table based on 3 different processes, all the required data from process A, process B, and Process C are combined in a single table. Then i created Forms each for every process wherein the data are those selected fields from the Table. Is this really possible? Because when i tried to enter data on my form i cannot proceed to add the records and it always having an error of "You cannot go to specified record."
What should i do? Do i have to create different tables for each pocesses? But the purpose i created a single table is that there are some fields that are related or same as the all other processes.

`up

 

[boblarson]

Hi Sir,
My file is 2.2mb which is beyond the allowable limit on this forum, therefore you may download it through the link provided below.

http://www.mediafire.com/file/zwjaihmxynf/changeover.zip


Thanks.

Sorry, it is blocked at work. Perhaps you could upload it to my ftp site.

I'll PM you the information.

 

[shieriel]

Sir i still cannot paste my file. PLease see photo of the webpage. When i tried to drag my file to the webpage, it just downloaded my file to my computer. Still no luck in pasting my file

 

[boblarson]

Sir i still cannot paste my file. PLease see photo of the webpage. When i tried to drag my file to the webpage, it just downloaded my file to my computer. Still no luck in pasting my file

Which version of Windows are you using?

Also, you might try using a free FTP client like FileZilla.

 

[gemma-the-husky]

can you copy your database, delete all the data, compact and repair, and then post the database?

i suspect that you have a normalisation problem, by combining what should be in different databases, into a single table

 

[shieriel]

Thanks for all your suggestions. But just now i found what is the error in my database. I just try to remove all the "validation rule" for every fields in my table and when i tried to enter data in different forms the error "you cannot go to specified record" disappears and the data i encoded just got entered into my table. I don't know why the table restrict a validation rule for it's field for this project.
But then again, thanks so much guys for helping.