Search results

Thank you all for your help, but I really don't know what to do. I am not sure about how to do that.

The thing is then I have already created forms for each table. But its not good in view of navigation, the user will be opening each form to fill out the details then.

I understand that using lookup fields is not good thing but how do I achieve that then. Any help would be appreciated. I need some of the fields to be multi-valued fields and lookup fields.

Another thing, my company wants to list out Incident details using "Inc_Num" field which is primary field in "tbl_Incident" and that's why I made "Inc_Num" as foreign field in all other tables as well. So on the Main_Form, it is placed on top of Tab Control so that only one Inc_Num is generated...

Ok but as I mentioned I am not familiar with any relationship or expert with the database. And if "Main_Form" is only based on tbl_Incident then it won't show other tabs right? I want all the tabs on a single form and data should go into respective table with same "Incident Number". Thanks

Hi, I have zipped my database with all the tables, forms and relationship. Please help me fix this. By default, the "Main_Form" will open where I need to AutoNumber to generate for all the tabs. This zipped database file is Access 2007/2010/2013 version in ".accdb" format. Thanks.

Hi, I am new to Microsoft Access and programming. My company has asked me to develop a database in MS ACCESS 2010. I have created all the tables and forms but I also need a Main form, where there is Tab Control to navigate these different tabs. These tabs represents data in different tables...