Recent content by mixup

Bob: Thanks a lot. That should do it.

I have a select query from a few related tables, one relationship being many-to-many. The resulting query, when run would have several groups of records where each group has all but one field different (a text field). Is it possible to do a report where this group appears as one record with the...

I think I have finally resolved it. I have the subform based on the relate table, which would only store OwnerID (through a list-limited combo-box)which would be a foreign key against the PlotOwnerLinkID, an autonumber. Also, I will have two unbound boxes in the subform that will display the...

Thanks Doc Man abd Craig. We are talking cemetary plots here (So no splits/combinations etc. involved) and thankfully our clerk's office do not need to track ownership percentages. They just have to list the owners. While I will make it a requirement that the OwnerTable is filled out first, the...

I am enforcing referential integrity (for the PlotTable and PlotOwnerTable through the PlotOwnerLinkTable). But still I end up putting in the same information multiple times in the PlotOwnerTable that already exists in the OwnerTable. (I hope I am understanding you correctly).

This is a design issue: I have a database with a PlotsTable and OwnersTable (table) in a many to many relationship, connected with a PlotOwnerLinkTable (that includes the PlotID and OwnerID Foreign keys). There is also an OwnerForm to allow adding owner details to the OwnerTable. The main form...

Is it going to be a bound picture or an unbound picture?

What about creating a query with the tables and creating a form from that query?

I looked at several threads on this issue but am still unsure as to how to solve this. I have a cemetery database which is somewhat different from the other situations discussed. The main form is a record of "Plots" which is based on a query. "Plots" and "Owners" have a many-to-many...

Thanks! Thanks for your reply ortaias. I actually went ahead with my relationships there. (I had to retain the Place abd plots as numbers). I did limit the the options through a drop down (1-6 and 1-2). As far as the relationship goes, I managed to do a 1 to 1 by not allowing duplicates in the...

As always, I am back to this forum for guidance. I am working on a cemetary database and trying to figure out the best way to set this up. Here are the rules: 1. the Cemetery has several lots. Each lot has exactly 6 plots, and each plot has exactly two places. 2. Owners can by plots. One plot...

Bob: Thanks for the post. Can you explain it a little bit more how it would apply to my case? My Access and VB/A knowledge is pretty limited. Thanks again.

Thanks to some of the threads here, I have managed to automate inputting form data from a record into bookmarks in a word document template (a letter). What I am trying to do is to lock the letter allowing modification only to the form fields in that template. If the original template is locked...

I found some information (from a previous thread) and this article: http://support.microsoft.com/kb/328320/en-us Using that I can get the information on two Different Reports. I am still trying to find out a way to combine the two.

I have searched and searched for a thread before posting this, there are some discussions on related issues, but I could not find a solution. This is my problem: I have a table with Incident_Type (a total of 6 selections from a combo-box), Incident_date, Incident_SubArea(25 selections from a...