Ok guys I need major help!!!
I need to create a form with a tab control that has about 4 tabs.
I have an address view, 3 tables. The reason why I have to use vAddresses as a view is because it is the city's main address database and everyone that uses it in their applications has to use it as a view. Which is fine. Then I have a tables called Services, Carts, Off Street Service. BTW, this is an application that tracks the Big Green Garbage Carts that we all use at our homes.
Here is what I need the form to do. I have a separate lookup form that searches for an address. Once the address is found I need it to go to the Main form and populate any and all information that is associated with that address but I need it to be in the different tabs. The main form will just show the address. and for instance, the services tab will have the billing information and information pertaining to the service; the off street service tab will have the information that pertains to off street service and the Cart tab will have information pertaining to the cart itself.
Here are my tables:
vAddress: AddressID, Address, Unit, Street Name, Street Type, Quadrant, Garbage Route
tbl_Services: ServiceID, AddressID, ServiceStatus, SerialNbr, NbrCarts, ServiceFee, BaseFee, ExtraFee, HURoute, HUAcct, HUClass, BusinessName, Remarks
tbl_OffStreetService: OSSID, AddressID, ServiceID, OSS_Status, StartDate, EndDate, CustName, CustPhone, CartLocation, Remarks
tbl_Carts: CartID, AddressID, SerialNbr, CartStatus, CartStatusDate, CartEvent, CartEventSubType, Remarks
I guess I'm just confused on how to tie all the four tables together to pull the information I need. All of the tables are related. Do I use a query that uses all the tables?
Maybe I'm explaining it wrong but I think I've explained it as best I can......
I need to create a form with a tab control that has about 4 tabs.
I have an address view, 3 tables. The reason why I have to use vAddresses as a view is because it is the city's main address database and everyone that uses it in their applications has to use it as a view. Which is fine. Then I have a tables called Services, Carts, Off Street Service. BTW, this is an application that tracks the Big Green Garbage Carts that we all use at our homes.
Here is what I need the form to do. I have a separate lookup form that searches for an address. Once the address is found I need it to go to the Main form and populate any and all information that is associated with that address but I need it to be in the different tabs. The main form will just show the address. and for instance, the services tab will have the billing information and information pertaining to the service; the off street service tab will have the information that pertains to off street service and the Cart tab will have information pertaining to the cart itself.
Here are my tables:
vAddress: AddressID, Address, Unit, Street Name, Street Type, Quadrant, Garbage Route
tbl_Services: ServiceID, AddressID, ServiceStatus, SerialNbr, NbrCarts, ServiceFee, BaseFee, ExtraFee, HURoute, HUAcct, HUClass, BusinessName, Remarks
tbl_OffStreetService: OSSID, AddressID, ServiceID, OSS_Status, StartDate, EndDate, CustName, CustPhone, CartLocation, Remarks
tbl_Carts: CartID, AddressID, SerialNbr, CartStatus, CartStatusDate, CartEvent, CartEventSubType, Remarks
I guess I'm just confused on how to tie all the four tables together to pull the information I need. All of the tables are related. Do I use a query that uses all the tables?
Maybe I'm explaining it wrong but I think I've explained it as best I can......