Newby Link Price Fields
Feb 20, 2006
So I have a table "InventoryTracker", with one field lookup set to list (drop down) and the source is another table "inventory", field "Item". This works good and all the items that I enter in the "inventory" table are available from the "InventoryTracker" table. Both "inventory" and "InventoryTracker" have a field called price.
Heres what I want to have happen.
When I select a item from the drop down list menue in "InventoryTracker" it automatically fills in the "InventoryTracker" price based on the price from the "inventory" table (for the item with the same name, the one I just selected). This has to be fairly straitforward, I can do it in excell, but not acess.
Can anyone help a newby out?:rolleyes:
View Replies
ADVERTISEMENT
Jul 9, 2007
Hi
I have a problem which hope will have a simple solution, which has been
driving me mad all day
I have a client who has two prices for the same service depending on speed
of turnaround
These prices are entered into the Client table seperately using the CDetails form.
I then wish to use this information using a combo box for selection within
another form called SDetails.However I can only get the combo box within
SDetails to put one of the two prices rather than either of the two choices,
because of the bound column within the combo.
The combo when pulled down looks something like this
Price 1 Price 2 Client Name
I would prefer for
Price 1
Price 2
so that I have the choice of the price I want to choose.
Having spent time and many brain cells, I have ground myself to a stop.
HELP!!!!!! if only for the sake of my sanity
View 1 Replies
View Related
Jul 29, 2013
I have a table called Books, in that table there is 4 columns ChapterName, Auther, ITEM, Price.
Each book has a item number, and each book has a few records with the same data, just the first column is different where its the ChapterName, each book has a price, but only once, meaning in the first record of each book it will be a price in the column price
Now I want a Query where i can get which book dont have a price at all, and which book has more than once a price, how can i do that?
View 1 Replies
View Related
Jan 24, 2007
Hello all, I've been reading through threads and there is alott of very good information on here, and seems to be some very knowladgeable people. So my question will probably be easy to answer.
I have a database of part serial numbers. I have created a query and a form to pull out all serial numbers for an inputed part number.
What I need it to do now is highlight any repeated serial numbers. How do I go about this?
I am thinking it will be a conditional format in the form itself to change font color but I dont know how to make it compare the values.
Any help would be great.
View 2 Replies
View Related
Nov 4, 2004
Hi,
Seems like the more i get into reading the more confused I get in this basic
fundamental. I just need it explained really clear and basic, then hopefully it will enter the subconcious and I will be able to proceed :)
I am trying to build with Access XP in 2000 version a small program for a small medical office.
Patients are offerd various services and they have vists to take advnatage of them. They are charged for the services and run an account which is then paid, leaving a balance.
I want it all to be entered via forms for older non computer literate staff.
I have done the main table okay with all the info we will need and I have messed around with the other 3 tables I think I need.
1. To enter the Services offered a description and fee.
2. Enter when they visit and what services they have and fees with total
3. When they make a payment and balance owing.
They are one to many relationships, correct?
For a start am I on the right track ?
My confusion is setting up the relationships especially what field/s has to be linked to fields in the other tables to make it work.
Is there a rock solid rule where a certain field has to be in each table and has to be linked ?
These are the first fileds in my MAIN TABLE..
Patient ID Auto Number Primary
Medicare Number Can be blank
Last Name Text
First Name Text
Address Text
SERVICE TABLE (Primary?)
Service Type /Combo- Accuncture-Massage-Herbs-Vitamins-Other
Description of Service Text
Charge for Service Text
VISIT (Primary?)
Date and Time of Visit: In case 1+ visits in one day
Reason for Visit
ACCOUNT
Date
Service Charges
Payments
Balance
I know it is basic but I need to get over this block..
Thanks in anticipation of help
Oz
:confused:
View 2 Replies
View Related
Jun 9, 2005
I have this form which shows the contents of a table... however, this table is linked to another table. How do I show the results of this linked table in the form?
Table_person
- Table_personID
- PersonFirstName
- PersonLastName
- EmployerID (linked to table below)
Table_Employer
- EmployerID
- FirmName
- ....
Now - the form should look like this:
First name: John
Last name: Doe
Firm: John Industries (selected in a dropdown box)
Table_Employer would contain
1 John Industries ...
2 Hank Industries ...
You catch my drift right?
How do I link these two tables in a form? How do I get the correct Firm to be selected in a dropdown box?
Any help is appreciated!!
Jazz
View 7 Replies
View Related
Jun 4, 2007
Hi All,
I am a complete novice with MS Access and am trying to find my way through our website database. ((URL address blocked: See forum rules)).
What I am trying to do is set up a search form to use offline so that it easier for us to trace animals that we have rescued.
I have the form all set up and it seems fine except that two of the fields I have on the form show numbers instead of the full details.
I think that what I need to do in those fields, is "point" them to another table in the DB so that they can "lookup" the relevant data in those tables and display the text instead of just the numbers.
I have tried searching through the MS Access Manual but to me, most of it may as well be written in a foreign language !
Hopefully t is a simple task that can be easily explained !
Regards
Paul
View 5 Replies
View Related
Nov 14, 2006
Heya, I know this is probably something simple as I know I have done sql problems like this before. However, I am wanting to show cars which have the same name but are of different colours (without duplicates), I figured I could just use a SELECT DISTINCT? However, when I do this it just brings up one car name and one colour when there are multiple colours.
SELECT DISTINCT car.carname ,car.colour
FROM cars;
I am guessing its because the SELECT DISTINCT statement is applied to both the name and colour.
If somebody could just tell me what I am doing wrong because I am guessing its something simple yet I am too frustrated to see what it is now!
Thanks =)
View 1 Replies
View Related
Jun 9, 2005
I have this form which shows an order.... linked to this order are the client, the principal company, and the company that carries out the order. The information for these three companies are all stored in one table (since the information is very similar).
Tables look like:
tblOrder
- OrderID
- ClientID * linked to CompanyID
- PrincipalID * linked to CompanyID
- Contractor (company that carries out the order) * linked to CompanyID
- Date
- ...
tblCompany
- CompanyID
- CompanyName
- CompanyAddress
- ...
An example is for instance:
tblOrder
- 1, 1, 2, 3, 01-01-2005
tblCompany
- 1, Comp A, 200 A Lane, LA,
- 2, Comp B, 100 B Lane, NY
- 3, Comp C, 300 C Lane, SF
So, on the form it should read:
Date of contract: 01-01-2005
Client: Comp A - 200 A Lane, LA
Principal: Comp B - 100 B Lane, NY
Contractor: Comp C - 300 C Lane, SF
I understand how to make one link to a form... but how do I make three links from the same table?!?!?
Any help is appreciated!
Jazz
View 1 Replies
View Related
Feb 3, 2005
i have a button that open another form. the form should copy some filed from the form that the button in it.
Example. i have the from-A with field name- ID. in this form there is a button that open form-B.
this form had also the field ID and another fields of information on the specific person (with the same person form the form_A)
i want that the ID will automaticlly updated whrn i open the form so i can add another information. these are teo tables that are linked together and that is the reason that witohut the ID it cant be updated, and i dont want to update it manually.
View 6 Replies
View Related
May 29, 2006
Anyone can help me how to link fields in different tables. Im creating a databse that has an ID. and that ID will be same with the ID on the other table.
Table 1
ID = 123
Table 2
ID = link to (Table 1 ID) and when i input characters on the Table 1 ID field it will appear or inputed also at Table 2 ID field.
Hope some ideas. Thanks
Michael
View 1 Replies
View Related
Oct 24, 2004
Can anybody help me, I have a database with over 4,000 records in one table and >800 contacts in another, I have company ID auto number in the site details and contact ID autonumber and company ID number in the contacts, I have an embedded table in the site form but when I try to enter new contact details it comes up with the error message
'the LinkMasterFields property setting has produced this error: 'Ambiguous name detected:call_click'
I have checked all the relationships and they appear to be ok. I have also rebuilt the subform but I still have problems, does anybody have any idea how I can fix this?
Jennifer
PS I am not a programmer so could you please reply in non technical speak.
View 2 Replies
View Related
Nov 7, 2005
Hi
Can you tell me if the following is possible and if so how to do it.
I have several different tables which require a date to be entered.
99% of the time this date is the same ie
(Table 1) Visit Date = (Table 2) Scan date 1
(Table 1) Visit Date = (Table 3) Scan date 2 etc.....
However in some cases Scan date 1 and/or Scan date 2 may not be the same as Visit date so the input does need to be editable.
Is there anyway I can link the information in Table 1 to automatically be displayed and stored in Table 2/3 and to be able to edit Tables 2/3 if the scan date is different to the visit date which it could be for a small number of records.
Is this possible or is it simply impossible to do this.
Thanks for any advice.
View 1 Replies
View Related
Jan 8, 2014
im creating a workers database and iam a beginner in access.i have created one table and a form like with the following details workers number ,name ,position attendancy and allowance so what i want is is i choose a workers number from the combo box all other details associated with the number should appear how do i do that?
View 6 Replies
View Related
Dec 1, 2006
Good Afternoon to all...
I am looking to link more than one field from my subform to my main form. I have one field linked by properties (link child field/link master field). Is there a simple way to link another field from my subform to my main form?
Please Help??? Cori
View 5 Replies
View Related
Sep 14, 2005
I need help! I've set up a database with a subform that worked until recently. I get an error message that says: The LinkMasterFields property setting has produced this error:'Invalid outside procedure'
I had added a date and time stamp for when something gets modified it changes the date/time. I even backtracked and took all that out from tables, forms, queries etc. but the error keeps appearing when I'm trying to update my subform.
Thanks,
supan
View 1 Replies
View Related
Dec 6, 2012
What I have is a table ('tblJobLog') with our main listing in it where we add customer job information as it comes in. The 'Customer Name' is a dropdown list that links to our table 'tblCustomers' so that we can ONLY select a customer name that we deal with. The alternative is to add a customer or list them as COD.
Now this is where I would like to target, the COD's. We still like to keep a record of who the COD is and we have some common customers that are listed as COD only.... So when we go to enter the customer name we have to put COD and in the description we are suppose to input the customer name (We will says RandyShop <--- me, for now).
What I would like to have done, if possible, is to see when we select 'RandysShop' from the dropdown, it checks to see if the COD Status (in the 'tblCustomers' table) is set to YES (its a check box, or YES/NO field). If it is set to YES (or selected) then the change the name shown in my main 'tblJobLog' to look something like COD: RandysShop.
The reason I would like, if possible, to do it this way, is because some customer go on and off COD regularly as the mess around with payment. So instead of creating a new customer that is listed as COD: RandysShop to have access do the leg work based on a simple YES/NO field (COD Status).
View 12 Replies
View Related
May 27, 2007
Hi
I have created 4 tables which have 3 field common in all these tables and carry the same data value. Is it possible to enter data in the first tables and it copies to other tables automatically. After all its the same 4 data fields in these tables.
Liver database
Table 1. Auto ID; Surname, First name, Patient ID;-----other not common fields.
Table 2. Auto ID; Surname, First name, Patients ID;----other not common fields.
Thanks
View 2 Replies
View Related
Mar 1, 2005
This is my first attempt with cascading combo boxes (2) and with the help of the forum I've made it work BUT, I feel like an idiot because I'm drawing a complete blank on how to link them back to a "main" data table.
The example I used as a reference was to create them as unbound boxes while using queries to pull for each of the combo boxes. I have 4 tables. One will serve as the main table while 3 others are each feeding one of the combo boxes. I went back and set the main table as the record source and added some of the other fields but those unbound fields have me stumped.
If anyone recognizes an earlier post that clarifies this, please let me know. I've looked through numerous posts but haven't found one yet.
Just like everyone else, any help would be greatly appreciated.
mike
View 1 Replies
View Related
Sep 30, 2015
I have an address field containing "City", Street Name, and street Address. How do I link these fields together on a form so that when I enter data into the "City" field the rest of the fields making up the address fills in?
View 7 Replies
View Related
Jun 13, 2005
Hello,
I have a form and a subform in MS Access 2003. I have made some changes to database structure, so I decided to change the subform also. When I changed the Link child and link master fields, the controls of the subdatasheet dissapear- they show only in design view. If I clear the contents of Link child and link master fields they appear again, but the records are not binded.
Is there a setting on the parent form that also has to be changed, to make the new binding?
Thanks,
Aleksander
View 1 Replies
View Related
Mar 14, 2013
I have a table "Product" and in this table I have two fields "StoragePlaceID1" and "StoragePlaceID2". Both these fields link to the look-up table "StoragePlace"
*Attached Image "Product_StoragePlace" from the Access Relationship Window"*
When I want to add a new Product from my inter face i get the error you can see in the Attached Image "Save_Error".I think the problem is that the Relationship is defined as One-to-Many,there a way to define the relationship as Zero-to-Many.
View 5 Replies
View Related
Jan 2, 2006
After being a member on this site for a while now I would like to get some opinions on "cost of application development" I know the forum covers a wide geographic area and the members cover a wide spectrum of degrees of expertise on Access and application development. So the question is this..What would your rates be and how would you determine your charges for developing Access applications for a business?PS... Please include your location if not in your profile.
View 13 Replies
View Related
Oct 13, 2007
I am creating a db that handles orders.
My problem is that the products being sold are so at different prices depending on the customer. (e.g I am selling 100 burgers to Mcdonalds for £50 whereas to Burger King I am selling them for £35).
Therefore I have split my 'Products' table into two. A 'Products' table which contains the product name and category. And a second 'Prices' table which contains the Product name, Customer and the price.
I have setup a relationship between the two tables based on product name
How to I go about looking up the different prices depending on which customer I have placed an order for?
can it be done in a table or do I need to create a query to sort it all out.
View 8 Replies
View Related
May 15, 2007
I am in need of some assistance. I've been looking on here for an answer, but can only find solution that would give me a by column lowest price, and I need to compare the prices by row. What I have is a table of vendor prices for part numbers we sell. What I want to do is compare all the prices the vendors for each part number and return the lowest and 2nd lowest fields in a query. Here is an example...
Part # vendor 1 vendor 2 vendor 3 Lowest Vendor Price Low Vendor #
10526 .75 .97 .67 .67 3
10527 .60 .82 .85 .60 1
Thanks for any ideas....
View 4 Replies
View Related
Sep 11, 2005
ok i didnt know what section to put this in so i put it here. what i wanna do is add a price change history to my database. for example is the price of an item is changed in my database i want to be able to see what the previous price was and when it was last changed, either in forms of reports doesnt matter i just need somewhere to view this info. problem is i have no idea where to start.
any help provided is muchly appreciated thanks.
View 4 Replies
View Related
