Forum home » Delegate support and help forum » Microsoft Access Training and help » database development in london - MS Access - best practice regarding forms
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
database development in london - MS Access - best practice regarding forms
Resolved · Low Priority · Version Standard
Reply Thu 9 Aug 2007, 10:16Delegate Frances said...
Frances has attended:
Access Introduction course
Access Intermediate course
MS Access - best practice regarding forms
Hi there,
I'm in the process of creating an Oracle linked database which has about 48 tables. All the tables have been set up and I'm now working on forms... A colleague has recommended that I restrict my forms to cover one table at a time as including multiple tables could lead to problems (unspecified)... Is this your view too? It was my understanding that you can join tables in queries and then generate forms from them.
My database will capture Marine monitoring data at the project/program/series/platform/instrument/geographic, and other levels....
Frances
For upcoming training course dates see: Pricing & availability
RE: MS Access - best practice regarding forms
Hi Frances
I have not used Oracle myself, but I do have a lot of experience with IBM DB2. I think you should be OK using forms across multiple tables. I do not know of any problems using from across multiple tables in Oracle.
I assume that you are creating the forms for data input. If this is the case I do not see why you would need to do a query. Queries of for data extraction. If you are doing an sql insert across multiple tables it would look something like:
insert table1.name, table1.a, table1.b, table2.name, table2.a, table2.b into table 1, table 2
Then if needed you can add on a where clause.
I suggest that you get a good grasp of what you are doing before you attempt it. Access is a very different database application compared to Oracle and implementing things learnt in access will probably not work with Oracle.
Hope this helps
David
|