field name must prompt a set price

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there -

I want to make sure that a particular transaction in a field name always
matches a particular price in the data type.

So,
 
ditnog,
Please provide a description of the fields (names, type, location..), what you want to
do (in detail), and WHY your doing this.
Carrying a duplicate value would seem to be redundant.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Actually - I don't want a duplicate value. I want particular fieldnames to
always have a certain currency attributed to them. Sorry if that doesn't make
sense - I know there's Access lingo and don't seem to be doing well
describing this.

I freelance. I want to know that when I work for my different companies,
that the price reflects the different rates I charge for each of those
companies. They vary depending on the company, but they do not vary within a
company. I'd like to enter the company name in a fieldname, and then have the
price reflected in a joined fieldname. I've gone down a couple of rabbit
holes, like trying composite keys, but apparently that will cause a headache
when it comes time to query.

So I think I want to make sure that my record with Company A will somehow be
unique, without making it a primary key.

Some days, this all seems easy, and other days not so much. Today, not at all.
 
I should clarify that the field names I have are: PublicationName (company),
address, phone number 1, phone number 2, article name, deadline, publish
date, and $ per word (going rate for the work, which I want to be constant)
and a field for what was $ actually arranged (so I can have two fields, one
for $/word and one for the actual cost of writing the article). I have a
separate table with ArticleName and fieldnames for those, but it's this table
that I'm struggling with. So, PublicationName A pays $2/word. Is there a way
to make sure that when I type in PublicationName A, $2/word comes up for the
currency?

Thank you
 
Back
Top