Search results

Pierre is my saviour again ;). However if I autonumber the Group ID field, then each name is given a different number in this field, so it becomes one-to-one, which won't work. If the problem is selecting the name, then I guess I will just have to have the Investor ID selected instead.

Cheers for your help, it's on the Data Entry/Groups form, adding new records to the Investors form.

To simplify data entry I am automating the entry of an ID number which is only neccessary to make a many-to-many table relationship function. The niftiest way to do this is with a counter, however using a control and VB to edit it doesn't fully work, because the counter resets every time I...

I have a combo box on one form that allows you to select from a list of names that come from a query of a table of people. However, whenever I change the value in a box, it causes it to create a new record in this table with the same name. Am I doing something wrong here...

Thanks! You've basically done what I wanted in your version, so I've copied that across to my version and it all works nicely, thanks. Incidentally this is some freelance work that I am doing, only I'm learning on the job ;).

I know that the Link Master Field property can be a control, however when I refer to a control in the main form it always asks for parameters (including asking for a parameter for '_'). If I remove the = sign from the property, this problem goes away, but the subform then doesn't change, which...

Well I'll try to explain then. There are a series of companies, and a series of investors. Investors form a collective group, which then performs a single investment into a single company. So a single company has a series of investments, by different groups of investors. A single investor can...

Gosh, I am going to have to shamelessly bump this before bed.

Is it possible to do so? If so, what is the syntax?

I will try to word this as best I can to explain my problem. I have a many-to-many-to-many database setup, where the important tables are the Companies and the Investors, with tables called Investments and Groups to act as go-betweens to enable the many-to-many relationship. So I have a form...