Search results

I`ve got the combo box to work but how do I delete a record? If I chose a record from the combo box and want to delete it, how do I do that?? I`ve tried using the button wizard and chosen the delete record but it doesent work, If I delete a record it doesent disapear from the table, it just says...

I have a table with seven coloumns, I`ve made a form with a combo box and 6 textfield, each representing one of the coloumns in the table. the combo box contains all the data in the first coloumn in the table. is there a way wich I can choose a value in the combo box and then view the record for...

Where do I set this???

I have a form where a user can enter data into seven textfield an push a button to add this info into a table. The problem I`m having is that the textfields are populated with the data that lies in the table. is there a way I can keep theese fields empty so the user just adds data and after they...

No I havent because I havent really made the form. I need help to make it.

I`ve trie it but I don`t know what to use to do what I want...

I have a simpe database wich is a tool register, the user can add more tools to the register and edit whatever he or she wants. How do I make a form where I can view a list over all the registered tools??

I`m having som trouble viewing the data I want to. I have 2 tables, tblserial and tblparts, in the table tblserial I have a list of products and in the tbl parts I have a list of the parts the products are made of. There are 4 "projects" that theese products and parts belong to. i`m using a...

It works fine except that when I choose a project, f.ex project 1 and then choose a part, say part 1 , I get a list of the parts, that`s great. but the thing is that I also lis the parts that belong to the same number but in project 2. If you know what I mean... It wont separate the parts that...

And what should I set the relationships to?Do I need one or two??

What about the relationship? just create a new one after I`ve deleted the primary key??

What should I set as the primary key instead then?? do I have to have a primary key at all??

Anyone?? I`m stuck here

I`m not sure if I understood what I am supposed to do with hte parts list... everytime I try to put something that alreadu exists in the parts list I just get the message"cannot save table, duplicated values". Is there something I have to do with the relationships?? I have lets`s say 4 projects...

They all have the same parts because ONE project results in a final product. let`s say it was a car they vere making, the car is put together by smaller parts, and the smaller parts ar made of som part if you know what I mean. Every car they made would be called a project and since all the cars...

thanks for the example.it helped me out ALOT. I was just wondering. for each project I have a list of parts with an art no. every project have the same parts with the same no., how do I "link" the right parts to the right project if I put all the parts in the same table??Do I have to make...

Another thing...since all the projects contail the same products an parts how does this keep track of which part belongs to which project??

Looking good but one question... If I first choose a project(let`s say nr 1) with the combo box and the click the product combo box to view the registered products for that project and then go back to the project combo box and choose another project and clicks the product combobox then the...

cool...I`ll try that then...but how will I be able to choose wich project I want to work with? make a combo boc for that too?? could you give me a small xample??

I cant put everything in one tabel because I have 4 tables that ar near identical but belong to different projects, I have one table for each project.