form linked with query and table

[luvbite38]

Hi guys,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am almost a stranger to MS Access and this is my only second attempt to create a small yet complex (for me) database.<o></o>
I have a database (lets call it DB-Banana), which is querying a another database (lets call this DB-Main). DB-Main contains information for all the products we sell, and DB-Banana query’ the DB-Main and shows only Banana product entries.<o></o>
Also, there is a form in the DB-Banana which is also linked with the banana query, so the banana department views their listings using query and add new listings using the form. So everytime when they add anything, it goes into the Main-DB. All is good so far…….. BUT now banana department want to add few more fields in their DB which cannot be added into the Main-DB and run some more queries, their queries has to be run on info from Main DB and new fields in their DB.<o></o>
<o> </o>
Is there a way, I can make some changes in the form so all the fields which belongs to Main-DB go to Main-DB and combination of Main-DB and new fields runs the queries for Banana Dpt<o></o>
<o> </o>
Example.<o></o>
<o> </o>
Existing<o></o>
DB-Main<o></o>
ID Product Fee<o></o>
1 Banana 100<o></o>
2 Banana 150<o></o>
3 Apple 100<o></o>
4 Guava 100<o></o>
5 Banana 300 (Auto Filled)<o></o>
<o> </o>
DB-Banana<o></o>
<o> </o>
ID Product Fee<o></o>
1 Banana 100<o></o>
2 Banana 150<o></o>
5 Banana 300 (new entry)<o></o>
<o> </o>
So if I add 5<SUP>th</SUP> Banana entry in DB-Banana, it will be autofilled in DB-Main<o></o>
<o> </o>
Desired<o></o>
<o> </o>
ID Product Fee Sales Manager <o></o>
1 Banana 100 Luvbite <o></o>
2 Banana 150 Angerbite<o></o>
<o> </o>
So if they want to add new entry this time, this only autofills same ID, Product, Fee to be auto filled in DB-Main, however, they now want to run a query Sales Manager Performance. So query one can be Performance of Ms Luvbite and the filter1 be on DB-Main on Banana and filter2 on Sales Manager.<o></o>
<o></o>
<o>Hope it makes sense???</o>
<o>Please help.......</o>
<o></o>

 

[guerillaunit]

Hi, you need to add a new column to the table on the "Main-DB" and a new column to the query on the "DB-Banana" for the sales manager info. Once you add the fields, you will have to go back and add the data associated with the field to the table on the "Main-DB" database.