Search results for query: *

Leslie, you are right. I read it once already, and thinking about reading it one more time. It is a good tutorial. Niles

Thanks Richard for everything. Also I like to thank everybody else for posting. As a beginner in Access I have been running into a lot of problems but at the same time figuring them out with your guy's help. I am going to reread this post and revise my project. At the same time, I am also trying...

Hi! I have a question regarding retrieving recor from a query onto a form. Here are the details what is going on. I am collecting information regarding properties. It contains the property owners information (Name, Phone Number, etc), property information (State, County, City, sqft, etc.), Loan...

That help a lot. It make it easier for me to understand. I am going to give you more info because my parent table only has one duplicate and that is PropertyId. Here is a link of my relationship table. This make it easier for me to express my situation...

I have many tables and I am using the graphical tool to link tables. Majority of my Pk's and Fk's should be autonumber because they are all Id's. For example, PropertyId, OwnerId, LoanId (Two or more loans), CostId, etc. I use these Id's to connect to my Property base table. The relationship are...

I tried to relate one of my PK called Property ID to a link table, which has a FK called Property ID. I receive a message box called, "Invalid field definition 'PropertyId' in definition of index or relationship" the field properties are the same, contain increment and is index but do not allow...

That makes sense. I have not put my PK ID's to autonumber. My three ID's act like autonumbers that they are just used for incrementing. I thing I do not want, is to have three text boxes (of these PK ID) on my form. I do not want the user to control the number sequence of the three ID's. What do...

I have a question regarding AutoNumbers. I have a couple of tables that have ID, that I want to be auto-increment. I do not really want to have it on the form but incremented with a value or decremented if the record is deleted. This ID field name is also a PK to relate with other tables. How do...

Final: I have a better question to ask then just submitting updates and thoughts. I hope this thread helps other beg. b/c it is helping me out. I have the relationships set up now. I took out the loanholder because the relationship with the table loan was not working out when I was doing some...

[Update:5] I made it relate by changing the loan_num field properties. Now, I am adding all the tables into a query and onto the form. It says that I cannot add or change a record because a related record is required in the table Loan_tbl1. I not sure what is needs, I guess place the PropertyId...

[New] Table: County_tbl Field Name: County (PK) ? I already input the county into the table, so user can just use the combo box to access which county the user wants to pick. Table: Loaninfo_tbl1 Field Name: Total_Interest_Owed Total_PrePayments Cash_To_Owner Assignment_Fee...

Thanks, I printed the article. I split the table because I thought you suggested it. All I am doing is tracking properties and their owners. Later on I want to track the dates of the properties being sold. I just to get moving on this project, due in 2 weeks. I will keep you updated. Thanks...

John: This is what I produced from what you are saying. Table: County_tbl Field Name: County (PK) ? I already input the county into the table, so user can just use the combo box to access which county the user wants to pick. Table: Loaninfo_tbl1 Field Name: Total_Interest_Owed...

This is what I got so far from the post. Let me know if there is something is missing. Parent Table: Property Child Table: Subordinate to Property-tbl Loan- I think what you said is how many and then have a child parent which is subordinate to this table (loan), would be the Loan Holder...

Thanks John. I am going to try this out. After doing this, I add all the tables into one query in order to sort by counties, then cities, and etc. I know I am getting ahead of myself, but after doing the tables relationship and query, I drag the tables into the form, in order for the end user...

So you are saying that Loan should be the Parent table-which retail and backgound info, be placed into the loan table a field names, is this correct? The reason I wanted the county to be the parent because on the form it is a drop down menu with the counties, then the rest is data entry of the...

I have a question regarding relationships between tables (Parent to its child tables). Here is my situation of this Access 2002 database program. Introduction: I am creating a form for people to enter in properties for my project at school. I want people to be able to select a county that...