Search results for query: *

The most complicated part of this (at least to me) is that a voucher may pay for multiple invoices, but it may also only pay for parts of multiple invoices. For example: Voucher A covers 25% of Invoice 1 and 50% of Invoice 2 Voucher B covers 75% of Invoice 1 and 50%...

I see what you are saying, but I have a slightly different setup than these two samples. Where as in the samples, the company is attaching invoices to a customer. But in my situation, it is more easily related to a company getting invoiced by others for doing a service for the company. Then...

I have been working on something that I feel should be very simple. It is a database for invoice and vouchers that pay for the invoices. On the basic level, it is a many to many relationship since one voucher can pay many invoices, and one invoice could be divided among many vouchers. So, I have...

Well I got rid of that error, (had to put it in the query behind the subform) but then it says that it can't be updated still.

I tried to make that work, but this is the error I get: The object doesn't contain the Automation object 'order_id' I have no idea what that means. I even tried making Order_id one of the items that linked to the subform, but that didn't work either.

I have a setup almost exactly like this page demonstrates: http://www.databaseanswers.org/tutorial4_db_schema/tutorial_slide_5.htm Just to keep using this example, say I create a form that is based off the Customer_Order table, and then inside I have a subform, based of the product table. I...

Just for clarity, I'm not worried about changing the PK, I just want to add more. But no new record is made in the related table.

Off of my test db, which I use to try to figure things out, and keep it very simple, I have 3 tables. Task Orders, Vouchers, and intermediate table TaskOrder_Voucher (created due to the fact that it is a many-to-many relationship between Task Orders and Vouchers) Task Orders has a composite...

I have a question that is very similar to this situation, just a different question about it. I have exactly what this person has, with the form and subform in order to do a many to many relationship, and I can edit and create new entries in each of the one-side tables, but the intermediary...

That link provided a very simple answer to my questions. Thank you very much to those who contributed.

Working with Access, I have created a few forms that allow for data entry. I noticed that in some of the cases that some of the forms do not allow the addition of new records, or the editing of any of the information. This seems to be completely seperate from the properties of Allow Edits, Allow...