Hi Guys.
I'm designing a massive a database with a multitude of tables, the employee number is >60,000 say.
Now - from my understanding as this is to be imported for Oracle later, I should stay away from Access specific functions - i.e. Lookups importantly.
I understand comboboxes are ok? as they are based on a table? Or am I wrong there too.. and should stay away from that.
More importantly, due to the sheer size of employees - will i manually have to select from the combobox - as I will not be able to do that for that many employees?
- so that is the question, should i be using combo-boxes and if so, can they be auto-linked for example, to the right department without manually selecting for each employee?
ps. As it is to be imported into an oracle/sql database later - what other things or functions should i stay from?
I'm designing a massive a database with a multitude of tables, the employee number is >60,000 say.
Now - from my understanding as this is to be imported for Oracle later, I should stay away from Access specific functions - i.e. Lookups importantly.
I understand comboboxes are ok? as they are based on a table? Or am I wrong there too.. and should stay away from that.
More importantly, due to the sheer size of employees - will i manually have to select from the combobox - as I will not be able to do that for that many employees?
- so that is the question, should i be using combo-boxes and if so, can they be auto-linked for example, to the right department without manually selecting for each employee?
ps. As it is to be imported into an oracle/sql database later - what other things or functions should i stay from?
HR Interim Database - for Oracle import later?
0 commentaires:
Enregistrer un commentaire