J
JoyJoy329
I am new to access. Currently I am trying to build a database for my company
that will keep track of the job flow. The structure of my data is connected
through a job number which is assigned by my company (and never repeats). The
table fields includes company info like company name, address, designer name,
phone # and emails… etc… a whole bunch of file received dates that includes 7
kinds of files and up to 5 updates per file… the factory flow which includes
when is the job started and ended in this department.. then the next
department…etc. I tried so many times to build these info into different
tables and make it work in the query and then form.. but I just couldn’t make
it work (that the record can be show when search for the job #)… so
eventually, I built one huge table which includes all the above information
and that’s the only way I could use my own way to solve the problem… and now
my boss is asking to add the ole link for each received file… and as usual, I
try to build it into my huge table and guess what? Access told me that
there’s 2 many columns… and now.. can anyone give me a hand on how can I
solve this great mess?? I created a separate table which contains just all
the received files on ole type… and my target goal is beside the file
received dates there’ll be an ole link and once click on it.. it’ll open the
file. If it’s possible, how can I split my original huge table into 2, one
for company info that I don’t have to enter it in over and over again?? if
the solution includes coding in SQL then can someone please be specific on
how to put the code in??
Thanks in advance…
that will keep track of the job flow. The structure of my data is connected
through a job number which is assigned by my company (and never repeats). The
table fields includes company info like company name, address, designer name,
phone # and emails… etc… a whole bunch of file received dates that includes 7
kinds of files and up to 5 updates per file… the factory flow which includes
when is the job started and ended in this department.. then the next
department…etc. I tried so many times to build these info into different
tables and make it work in the query and then form.. but I just couldn’t make
it work (that the record can be show when search for the job #)… so
eventually, I built one huge table which includes all the above information
and that’s the only way I could use my own way to solve the problem… and now
my boss is asking to add the ole link for each received file… and as usual, I
try to build it into my huge table and guess what? Access told me that
there’s 2 many columns… and now.. can anyone give me a hand on how can I
solve this great mess?? I created a separate table which contains just all
the received files on ole type… and my target goal is beside the file
received dates there’ll be an ole link and once click on it.. it’ll open the
file. If it’s possible, how can I split my original huge table into 2, one
for company info that I don’t have to enter it in over and over again?? if
the solution includes coding in SQL then can someone please be specific on
how to put the code in??
Thanks in advance…